[AccessD] Append Query Problems

The easiest way to find this out is to cut and paste the data. The 'bad' 
stuff will go into 'paste errors' table.
_d



"Things are only free to the extent that you don't pay for them".-Don 
Elliker





>From: "Tim Thiessen" <tim at irwin-greenhouses.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessD at databaseadvisors.com>
>Subject: [AccessD] Append Query Problems
>Date: Fri, 1 Aug 2003 14:22:25 -0500
>
>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?
>
>Tim Thiessen
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail