I need some advice on the best procedure and a couple of shortcuts if anyone has already done this. We have recently combined lots of data from different sources and there is a large number of unchecked records.

The result of this is that it is now difficult to use the 'Display unchecked records' in the sensible way intended.

I realise it is likely to be regarded as bad practice to suggest we 'check' some of these records automatically but I wonder if anyone has a query we can run to 'check' a survey at a time?

To compound our problem, we now have several people entering data into the same database on the network and I would be grateful for any suggestions of protocol for this. I must now make sure everyone gets their records checked soon after they are entered. Has anyone out there a query which returns all the records entered by someone between particular dates? (rather than just a count of them!)

many thanks in advance!
Philippa