Need help with criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Criteria in append querie 3
I need help with query criteria 2
Criteria No Longer Works 1
microsoft access 1
Update query Criteria help needed 2
Use criteria in field for fieldname in query 2
Add criteria to a append query 2

Back
Top