Union Query - enter data to search (1 Viewer)

mshoems

Registered User.
Local time
Today, 11:53
Joined
Dec 15, 2009
Messages
12
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

Registered User.
Local time
Today, 11:53
Joined
Dec 15, 2009
Messages
12
Nevermind, I think I have it figured out. I created the union query with just select statements then created another query based on the union with the criteria that I wanted to pull. I guess I just needed to write it down to figure it out.
Thanks.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom