Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 04-13-2010, 05:09 AM   #1
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


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
Select * from qrySearch_Cancel
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.


mshoems is offline   Reply With Quote

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 04:41 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

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