 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Queries
Dear Sirs, I have two select queries. I would like to combine the data from this two, into one query (something like merging the data) - query 1 + query 2 = query 3 Can someone tell me how to do do that? Thanks Klaus It depends... We're not there. We can't see what you're doing. Post the SQL of the two queries as well as information about what the queries do and what you would like this 3rd query to output and we'll get back to you. Cheers, Jason Lepack > Dear Sirs, > I have two select queries. [quoted text clipped - 3 lines] > Thanks > Klaus Use a union query. Create your new in design view and do not add any tables. Click on SQL view button on the toolbar Type SELECT ALL * FROM [Query 1]; UNION ALL SELECT * FROM [Query 2]; Save your new query 3 > Dear Sirs, > I have two select queries. [quoted text clipped - 3 lines] > Thanks > Klaus I get the error message: Syntax error (missing operater) in query expression '*[query1]'. Can you tell me what that means? Thanks Klaus > Use a union query. > Create your new in design view and do not add any tables. [quoted text clipped - 12 lines] > > Thanks > > Klaus You need the word FROM and a space and the actual name of your queries instead of query 1, query 2 * FROM [The name of your query]; > I get the error message: Syntax error (missing operater) in query expression > '*[query1]'. [quoted text clipped - 18 lines] > > > Thanks > > > Klaus |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.