Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
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
Old 04-13-2010, 05:42 AM   #2
mshoems
Registered User
 
Join Date: Dec 2009
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
mshoems is on a distinguished road
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.
mshoems is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query Error - Can View Data But Not Enter Jared Queries 18 07-29-2009 01:10 PM
update query lala Queries 42 08-27-2008 07:18 PM
Outer Join creating duplicates in dynamic query search results dillonhh Queries 4 01-28-2008 12:51 PM
Can't enter Data into a query Sharon Hague Queries 1 08-08-2003 12:09 PM




All times are GMT -8. The time now is 07:48 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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