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
 
Back
Top