How do I find missing data in a many table?

K

ksj

I have two tables with a one to many relationship. The unique numbers are
well numbers. The second table is historical data with many entries for each
well. I have a field named action which is also a combo box so I just pick
which action has taken place for this entry. I want to be able to list all
the wells that have been entered in the first table that "do not" have a
particular action in the historical table.
 
D

Douglas J. Steele

There's a Find Unmatched Data query wizard that should help you get what you
want. Indicate that you want a new query, select the Find Unmatch Data Query
from the list of possibilities and follow the instructions.
 
K

ksj

Not quite what I was looking for, I'll try to be a bit more specific.

The one table will have the well number and specific descriptive fields of
"all" the wells. The many table, or history as I've named it, will have the
well number and an entry for each "historical" event that takes place. The
combo box in the history table where I enter the event that took place could
be, drilled, completed, MIT, abandoned, reclaimed, etc. The history table,
or many table, could have several entries for each well (or may have none if
it is a newer well) but may be missing the one record for a particular event,
such as abandoned. I want a query to show the well from the one table that
does not have a particular event happening in the many table.

Please try again. I'm a new user and am baffeled.
 
Top