nonappending records

  • Thread starter Thread starter sierralightfoot
  • Start date Start date
S

sierralightfoot

How can I find the records that are not appening in a query, and what field
is the issue?
 
There is no "easy" way, unfortunately, unless you go ahead and do the
append, and then compare the table's contents to the original data source
for the records being appended. Otherwise, you'll have to do a lot of
debugging to find the records that won't append if you don't do the append
query at the time you get the error.
 
Similar question: similar answer? In append query some fields are set to null
because....How do I find records and fields?
 

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

Problem when I change the starting value of an autonumber field 2
Appen Query with new records only 1
Code or Macro maybe? 2
seeing the append query before updating records 3
Update and Append Query 16
Using append/update queries to transfer record data from one Table to another Table 1
Someone pleast help.... 1
Use of Nz Function in expresion 1

Back
Top