Robert Raley wrote:
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;

Each SELECT statement in the UNION query has to have its own WHERE clause. As
written the WHERE clause will only apply to the last SELECT. Was that your
intent?

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