Parameter query where blank is like "*"

  • Thread starter Thread starter Dirtbike
  • Start date Start date
D

Dirtbike

I have a form and a paramter query. I want to be able to know that if the
form field is blank just give me all your records.
I tried IIF(Forms!Form1.Vend is NULL, "Like "&'"*", Forms!Form1.Vend) but
get no records when the field is blank.
Thanks for the help!!
 
Dirtbike said:
I have a form and a paramter query. I want to be able to know that if the
form field is blank just give me all your records.
I tried IIF(Forms!Form1.Vend is NULL, "Like "&'"*", Forms!Form1.Vend) but
get no records when the field is blank.
Click to expand...


Try using the criteria:

=Forms!Form1.Vend OR Forms!Form1.Vend 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

#error - Blank 3
form query 11
IIF questions with < or > signs 1
Parameters query 1
Blank fields 3
optional parameter for query 2
Controlling a WHERE with a checkbox 5
Problem with Criteria 12

Back
Top