By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,201 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Merge two Queries

P: 77
Please help...

I have 2 queries with the same type of information,

Query1 has the columns - CaseID, PlaceDate, MailDate, Before, After
Query2 also has the same columns, but Query1.CaseID does not match Query2.CaseID. CaseID is what I use to join the queries.

What I am trying to do is merge both Queries and make them into one Query.

Please help
Dec 13 '07 #1
Share this Question
Share on Google+
1 Reply


P: 30
What you may be wanting is a UNION query that combines the two queries into a single recordset.


Please help...

I have 2 queries with the same type of information,

Query1 has the columns - CaseID, PlaceDate, MailDate, Before, After
Query2 also has the same columns, but Query1.CaseID does not match Query2.CaseID. CaseID is what I use to join the queries.

What I am trying to do is merge both Queries and make them into one Query.

Please help
Dec 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.