Robert Raley wrote:
Access 2003

I am using a query to return a group of products. in the criteria
box I have this

[Please enter product number] Obvisouly when the query is run the
user is prompted to input the product number. This works great.

What should the user input to return all products or what is the code
to write for the criteria.

Thanks

Bob Raley

For your criteria use...

[Please enter product number] or [Please enter product number] Is Null

If the user enters nothing in the prompt you should get all records.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com