ignore if null

[karim]

Hello All,
I am trying to write a qry that will be filtered by some pop-ups
when the user open it. What I want to do is for the customer pop-up, if the
user don't type the customer's name, it would show all the customers and
ignore the empty space. I tryed "Is Null" in the criteria area before and
after the [type cutomer name] and it did not work. I also tryed it on a
separate row and it also did not work. Does anyone know of a way that works?

Thanks for the help.

 

[Gina Whipp]

Karim,

Try....

Like [Type Customer Name or ENTER for All] & "*"

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[karim]

Thank you guys, worked good. I apperciate it.