Can someone help me with this

[hmho]

I have form bas on Table that has these fields [ID] [Salesdate] [SerailNumber] [BookNumber] [EndingNumber] and the table name is TblSales. How do I code for a form that will show me all [SerialNumber] where there was [EndingNumber] on the perivious date but there is no EndingNumber entered on current date. Forexample

[ID] [Salesdate] [SerailNumber] [BookNumber] [EndingNumber]
1 07/01/09 1234 1022 125
2 07/01/09 1222 1028 130
3 07/02/09 1234 1022 156

In this senerio I would like to see SerialNumber 1222 since there was entery on the previuos date but no entery on today.

 

[gemma-the-husky]

this may not be what you mean, but

a) have one query finding entries for today
b) have another query finding entries for yesterday
c) have an unmatched query finding discrepancies

HOWEVER

if you really mean, go through the table item by item, looking for entries with no entry in the preceedng day, whatever date you have - then this is easiest done by code.