Parameter not working in Union Query 1

[annie52]

I want the query to display only one record when the user enters a Control #. However, it displays all records from one source (query) and none from the other query. When I don't include the Where clause, I can see all of my records from both queries.

Select [QDRNum] As [QDR/SDR], [Control], [Location], [JD], [Serial]
From [qryReqnsByQDR]
UNION Select [SDRNum] As [QDR/SDR], [Control], [Location], [JD], [Serial]
From [qryReqnsBySDR]
WHERE [Control]=[Enter the Control #]
ORDER BY [Control];

Thanks in advance for any ideas you may share.

 

[PHV]

What about this ?

Select [QDRNum] As [QDR/SDR], [Control], [Location], [JD], [Serial]
From [qryReqnsByQDR]
[!]WHERE [Control]=[Enter the Control #][/!]
UNION Select [SDRNum], [Control], [Location], [JD], [Serial]
From [qryReqnsBySDR]
WHERE [Control]=[Enter the Control #]
ORDER BY 2;

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[annie52]

Wow! You saved me twice today. Thanks a million.