Please help- anyone

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
Back
Top