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

 

[mscertified]

Need layout of your table which stores Palm and Trial data.

-Dorian