using the * wildcard

[chainedtodesk]

i am trying to use multiple options in a report one is included, my goal is if they have not selected an option from one of the drop downs that the query would look at it as * and pull in all records for that field and move along to the next one, if i select something it works but the * isnt working, thanks

IIf([Forms]![frmReports]![rptcond1]=0,"*",[Forms]![frmReports]![cboAnalyst])

 

[PHV]

Use the Like operator:
Like IIf([Forms]![frmReports]![rptcond1]=0,"*",[Forms]![frmReports]![cboAnalyst])

Another way:
=[Forms]![frmReports]![cboAnalyst] OR [Forms]![frmReports]![rptcond1]=0

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[chainedtodesk]

worked like a charm, thanks