Please help- anyone

C

Chris

I have two queries that I created from two different tables. Each one pulled
data from a 3rd table. Now I'm trying to merge the two queries into one big
table so I can maniplate the data into different reports. One query has
qualified competiors and the other non-qualifying competitors. I want them
all together, using an ID field that was created by someone in EXCEL, that I
converted to Access. I just want all my competitors in one table, not
careing what level they are. Can anyone help me....Please I'm desperate.
 
A

Alex Ivanov

Chris,
Try to create a Union Query like this:

select * from qry1
union
select * from qry2

make sure qry1 and qry 2 have the same number of fields and corresponding
fields are of the same type.

Then, if you need it, create another maketable or append query based on this
union query.

HTH
 
C

Chris

Thanks, I'll give it a try. I was trying to merge both queries into a table
and pulling a field from the queries to update a field in the table but it
wasn't working. I'll give this a try and see what happens
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Create a dynamic master file 1
Mail Merge Help 1
Create a chart from a table in word thats dynamic 0
Auto Merge text from multiple sources 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Help creating a search form in Access XP 0
Some mail merge fields not pulling into document 2

Top