Using wildcards in a SQL statment

[mokeyone]

I am trying use an IIf command to limit the query if a checkbox is checked and not limit the query if not checked. Can someone show me what I need to put in the false part of the IIf statement to get all records? I am using Access 2003.

WHERE (((StudentTable.Startdate)<[Forms]![AuditReportForm]![txbTo])
  AND ((StudentTable.EndDate)>[Forms]![AuditReportForm]![txbFrom])
  AND ((StudentTable.PaymentType)=IIf([Forms]![AuditReportForm]![ckbWFonly]=True,"W/F", "%")))

[Rabbit]

I suppose this should work: "Like '*'"

[mokeyone]

Thanks it did help.

I needed to change the = before the IIf to Like, then the IIf supplied the patterns

[Rabbit]

Not a problem. Good luck.