basic question about join

[phil009]

Hi, I have a simple question but since I am relatively new to Access I don't know the answer. I have one table ("first2") and one query ("04") which both have the exact same format. It looks something like this:

RR Year Comm W1 W2
XX 1999 1 123 144

Table "first2" has my data up until 2004 and query "04" has my results for 2004. What I would like to do is just join the two together so that it makes one big table. I can give you any other information that is neccessary. If anyone can give me any tips they would be greatly appreciated.
Thanks,
Phil

 

[PHV]

Take a look at UNION QUERY

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[phil009]

PHV-I looked into the Union Query and it was just what I needed. Thanks a lot for your help.

Phil