Append query error

[gc]

I have a table which links to a text file. When I use an append query to add some data to a table. Sometimes I got error message "Numeric field overflow". But the wierd thing is after I save the query and run it's OK. But when I run the query again I got that error message again. Please help me to solve this problem and thanks in advance! George

 

[kerrigirrl]

i posted a message like this a few weeks ago to no avail. i didn't come across the 'save' solution until last week though.

in my query, i notice that a date/time field (not involved in the query at all, but in the table i'm getting the information from) was empty. this caused it to error with #Num in the date field of the table.

i have no solution, just wanted to let you know, you're not the only one!

kerri