Need help with criteria

C

Charlie

Hi,

I want to run an append query which will take all the information from one
table to another but excluding a record which has become corrupt and has
#Error in each field. Could anyone let me know what criteria I need to put
in, so this will run correctly.

Thx in advance

Charlie
 
A

Allen Browne

The crucial thing is not to refer to the bad record.

If you have an AutoNumber field that is 47 for the bad row, create a query
with critiera of:
<= 46 OR >= 48

In this way, there is no attempt to read record 47.
 
Top