Criteria

  • Thread starter Thread starter Steven
  • Start date Start date
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.
 
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])
 
Back
Top