Finding Nulls After Append Query

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
 
A

Allen Browne

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

Tony

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
 

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 2002 Append Query Problems 2
Appending zero-length string 4
query field names changing to expr#: 8
Append to two different tables 23
Data changes in append query 1
Running into error while writing Append Query 3
Append query wont run because: 8
Appending Records Using DMAX 5

Top