Missing Entries

[c8tz]

Hi,
I have a palms table that stores palm census for each and every palm
for a block on every trial.
Every trial has a set number of blocks and set number of palms.
Each of the palms has a palm census done every year to check its
status.

The problem firstly is that for data entry: Entry is done such that
the trial, plot is entered, and also palm number and the status.
Sometimes not all the palms are being entered, so there are a few
missing palms that have no status in a year and then in the next year
it is entered.
I would like to do a query that picks up those palms that have not
been entered. Firstly there is nowhere in the db that states the
total
no of palms for each plot - there is only total no of plots for the
trial.
i have decided to change the data entry form such that the palm
number
is not entered but should automatically show, so that a palm is not
missed.
i need help to how to pick up from the current data which palms are
missing.
Great appreciation for all assistance given,
Thanks

[Larry Linson]

This seems to be "our day for cryptic questions." Without some specific
details, it's going to be difficult to help you. Of what information does a
"palm census" consist. Are these "palms" as in palm trees, or "palms" as in
the inside of a closed hand? Do you me "trials" as in "trying something
out" or do you mean "trails" as in "pathways". How does one determine the
number of a specific palm? How is the data stored -- you say you have a
palms table, and would it be feasible to tell us what information is kept in
that table? Is there a separate record in the palms table for each year's
status entry? Do you try to keep multiple year's status on a palm in a
single record? How do you relate a palm to the block in which it resides --
is there a separate, related block table (and a foreign key to the block in
the palm table)?

Larry Linson
Microsoft Access MVP

"c8tz" <cc*****@gmail.comwrote in message
news:11*********************@i13g2000prf.googlegro ups.com...

Hi,
I have a palms table that stores palm census for each and every palm
for a block on every trial.
Every trial has a set number of blocks and set number of palms.
Each of the palms has a palm census done every year to check its
status.

The problem firstly is that for data entry: Entry is done such that
the trial, plot is entered, and also palm number and the status.
Sometimes not all the palms are being entered, so there are a few
missing palms that have no status in a year and then in the next year
it is entered.
I would like to do a query that picks up those palms that have not
been entered. Firstly there is nowhere in the db that states the
total
no of palms for each plot - there is only total no of plots for the
trial.
i have decided to change the data entry form such that the palm
number
is not entered but should automatically show, so that a palm is not
missed.
i need help to how to pick up from the current data which palms are
missing.
Great appreciation for all assistance given,
Thanks