I'm getting this error message :You tried to assign the null value to a variable that is not a variant data type" when i run an append query.
The query worked fine in the past with smaller data sets - first time this has happened. No other changes to the query. I tried using top 1, but still get error. I changed to Select query and it worked fine. I checked the properties of all the table fields - no "Required" fields and "Allow zero length" is set to "YES" for all text fields. Any other suggestions?