Criteria

S

Steven

I need help with this criteria statement of a query where
I am saying if Field Combo01 is Null then give me all
records but if Combo01 has a value then query records
matching that value.


IIF(IsNull([Form]![Form01]![Combo1]),Like "*",[Form]!
[Form01]![Combo1])


Thank you for your help.
 
D

Duane Hookom

You can't place the " Like" inside the expression. If you field name is
[City] then you can use an expression like:
=Nz([Form]![Form01]![Combo1], [City])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIf statement in query criteria 5
criteria failure 7
Show all records with a keyword ex:"ALL" 3
using Like in query 1
Access Dcount (multiple criteria) 3
parameter query 1
Combo box contents doesn't change when filtering combo box is chan 2
two null fields 4

Top