Hi Rick you suggestion worked great with the query that I was using, thanks.

I applied the same principle to a union query that I am using and now matter
what I input the return is all. Please take a look and tell me what I am
doing wrong. Thanks Bob

SELECT ContId, com_name, studio FROM qry_mod_min_F4F;
UNION
SELECT ContId, com_name, studio FROM qry_mod_min_PS;
UNION
SELECT ContId, com_name, studio FROM qry_mod_min_DS;
UNION
SELECT ContId, com_name, studio FROM qry_mod_details;
UNION
SELECT ContId, name, studio FROM qry_mod_insurance;
UNION
SELECT ContId, com_name, studio FROM qry_mod_manager;
UNION SELECT ContId, com_name, studio FROM qry_mod_shift
WHERE (((studio)=[Please enter studio number] Or [Please enter studio
number] Is Null))
ORDER BY studio, com_name;




"Rick Brandt" wrote in message
...
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