merge data from 2 query

[Guest]

I have a table with records from A to Z
Query 1 has records a, b, c
Query 2 has records c, d ,e
I want Query 4 to get all the records from Query 1 and 2 : a, b, c, d, e
Might sound simple, but that got me puzzled.

Thanks

 

[Graham R Seach]

ion,

In order for the resulting dataset to be meaningful, there must be something
to link the two tables on. What is the common field between them?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Guest]

Graham,

Thanks for trying to help. We are talking tournaments, so team A competes
against team B, the winner gets some points. Simplified to illustrate the
pronlem, it looks like this:

Table is as follow
Team1 Team 2 Score team 1 Score team 2 Points team1 Points team2

A B 10 3 2
0
A C 12 6 2
0
A D 10 10 1
1
B C 10 3 2
0
C D 10 3 2
0
D B 10 3 2
0


Query 1 takes Team1 and adds the points
Query 2 takes Team 2 and adds the points

In Query 3, I want to get the total points for each team. However, in the
example above, team A is never in Query 2, and therefore does not show up in
Query 3.

 

[Graham R Seach]

There must be something to link the two queries together; a primary
key-foreign key relatonship perhaps?

So I can get a better picture of what's going on, can you show me the two
queries you already have? Also, let me see the structure of the table(s)
involved.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------