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
Need help with ADP- Stored procedure using select query and criteria 0
If null then no criteria 6
using Like in query 1
Split form 0
Show all records with a keyword ex:"ALL" 3
Criteria to return all records if selection from form is null 4

Top