Combine Two tables

[Tom Rymes]

Folks,

Please excuse me if this is an obvious question, but I haven't been able
to find any information on this. I have two tables, as follows:

Table one contains these fields:

AccountNo - Key
Division
Name
Street1
Street2
City/state
ZIP

Table two contains these fields:

AccountNo - Key
ProductNo - Key
Gallons
Dollars

Every record in table two should have a corresponding record in table
one, but not every record in table one has a corresponding record in
table two. The tables are related one-to-many via the accountNo field.

Using a query, I can get combined info for each account including name
and gallons, product, etc. What I don't know how to do, though, is to
find those records in table 1 that have no corresponding records in
table two.

How would I go about this?

Again, pardon me if this is a.) obvious, or b.) the wrong place to ask.

Tom

 

[Tom Rymes]

Build an UNMATCHED query. The query wizard offers this as one of the
options.

Thank you, Rick. That was just what I was looking for. I also realized
that I asked the wrong question with the wrong subject line in the wrong
newsgroup. DOH! I was originally going to ask a different question
completely when I figured that our and started to ask another.

Oh well...

Tom