Query Criteria

[rjm13]

Hi all,

I have something I think should be simple, but I can't figure it out. I have a query in access that I developed in the query grid. For the Name field I have criteria that checks a selection made on a combo box on a form, that works fine, the problem is that I want the query to return rows of all the names if nothing is selected in the combo box. My question is what syntax should go into the criteria line in the query grid. Any help is much appreciated.

Thanks,

R

 

[traingamer]

See faq701-3177

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[rjm13]

Thanks Greg, thats what I needed.

R