Query Problem 2

[AccUser]

I have two tables. Table "A" has records pertaining to year 2000. Table "B" has records pertaining to 2001. Note that there are NO PRIMARY KEY in either table. I combine 3 fields in each table to make a key and join the tables from this field.

How can I show all records in Table "A" and any matching records in Table "B" and vice-versa?

What I get is only a partial listing from Table "A" and the matching records from Table "B". I need to extract all the records from the first table.

This should be simple, but for some reason, i 'taint workin'.

Any advice.

 

[gwinn7]

When you examine your query, did you make a LEFT/RIGHT join? By default, I think joins are INNER. It seems like a LEFT or RIGHT join is what you want. MS ACCESS help has good help topics on this subject. Just look up "JOIN" in the Help Index.

Gary
gwinn7

 

[AccUser]

Your right! I did not make it a left-right join. Once I did that, I saw all my records from Table "A".

Thank you.