Iif trouble

G

Guest

Im trying to query a table with one of the criteria being from a Combo box in
a form. There are 2 options in the field, but if the user leaves it blank, I
want to pull both options. Right now, I have
Iif([Forms]![Main].[Combo35] Is Null, ????????????, [Forms]![Main].[Combo35])
I need the ???????? to pull everything regardless of the data in that field
 
G

Guest

Forget the IIf. Use this as the criteria:

Like [Forms]![Main]![Combo35] & "*"

It's possible that the above could cause problems. For example if an option
is "A", the statement would bring in all data beginning with A.
 
F

fredg

Im trying to query a table with one of the criteria being from a Combo box in
a form. There are 2 options in the field, but if the user leaves it blank, I
want to pull both options. Right now, I have
Iif([Forms]![Main].[Combo35] Is Null, ????????????, [Forms]![Main].[Combo35])
I need the ???????? to pull everything regardless of the data in that field
Click to expand...

Forms!Main!Combo35 OR forms!Main!Combo35 is null
 

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

Default value 3
Combo Box Fills In Calculated Text Box 3
Query driven by form field 1
If statement that returns all entries or one 2
criteria for date field using iif() 1
Conditional IIF question/null value 2
blank for criteria in query field 10
IIF in a query 3

Top