Finding Nulls After Append Query

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi All,

I'm running an append query that tells me that some field values were set to
null due to a type mismatch. It's appending over 11,000 records and I'm
looking for a relatively easy way to find and isolate the records with the
offending values.

Any advice?

Thanks & Ciao,

Tony
 
See if there is a table named something like PasteErrors.
If so, it should contain a list of the problem records.
 
Thanks Allen,

There's no such table but I found the errors in the data after writing a few
queries to track things down.

Ciao,

Tony
 
Back
Top