The Overflow Error

[kbsudhir]

Hi All,

I haev created a query with 16column in Access 2003. It was working properly with test data but when I update 100lines of data in the table & then tried to execute the query, Iam getting "Overflow" error.

What is this error & how can I overcome this error.

Please help.

:dunno :dunno

:banghead: :banghead:

Thanks for your time
Sudhir

[CreganTur]

The 'Overflow' error is a bit of a catch-all error; it could be caused by any number of things. Are you performing any calculations on your data within this query? Are you sure the record data matches up with the data types required by the query?

Can you post the SQL for the query and provide an explination of what it's trying to accomplish?