View Single Post
Old 04-13-2010, 05:09 AM   #1
mshoems
Registered User
 
Join Date: Dec 2009
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
mshoems is on a distinguished road
Union Query - enter data to search

Hello.

I created a union query based on three different select queries. When the query is executed, I want the user to be able to enter specific data to search on. Each select query has the same field name for the search.

This is what I currently have.

SELECT * from qrySearch_Active
Union
Select * from qrySearch_Cancel
Union
Select * from qrySearch_Mod
Where Number = [Enter search parameter]

I want to select all of the records from each query and output the search criteria for the user to view. I can run this and I get a dialog box that asks for the search parameter but then gives me every result from every query.

Any help would be appreciated.

Thanks,
Marc

mshoems is offline   Reply With Quote