Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Queries (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=8)
-   -   Union Query - enter data to search (https://www.access-programmers.co.uk/forums/showthread.php?t=191399)

mshoems 04-13-2010 05:09 AM

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 04-13-2010 05:42 AM

Re: Union Query - enter data to search
 
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.


All times are GMT -8. The time now is 04:40 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World