Parameter query where blank is like "*"

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!!
 
M

Marshall Barton

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
Blank fields 3
Parameter Query based on Form 2
List all records but ... 3
form query 11
If statement that returns all entries or one 2
Problem with Criteria 12
Query criteria - exclude data and return all records if null 3

Top