[AccessD] Append Query Problems

Hi Tim

> I am using A97.  I need to append the records from one table to another
> identical in structure.  The query gets about half way done and then stops
> with the following error message:  "You tried to assign the Null value to a
> variable that isn't a Varient data type."  I am assuming that there is
> corruption in one of the records.  How do I go about finding that record?

Do a binary approximation ... append half of the records. If it has no
errors, append the other half - this should fail.
Now, follow this route by appending half of the failing recordset and
so on - eventually you'll have tracked down the failing record.

/gustav