Access 2000 Numeric Field Overflow

G

Guest

Hi Groupies

One of my students has asked me a question and I thought I would throw it
out to you all.

She has a database that was developed for her. There is a possibility that
the data originally came from Excel however, she does not think that the data
is currently linked in any manner to Excel.

When she runs a query that performs a COUNT, she receives the message
"Numeric Field Overflow".

I know that this can be a problem when using a linked Excel table but is
there any other reason for this to occur? Her query has thousands of records
but that should not be a problem in Access.

Any thoughts or ideas?
 
G

Guest

It could be that the datatype is set to integer, try make it a double (the
numerical field that is)

Maurice
 
G

Guest

Hmmm, well that's a thought isn't it.... Any particular reason why you
suggest Double, wouldn't Long Integer do the same thing?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numeric Field Overflow Error 5
Numeric Field Overflow 1
Numeric Field Overflow when appending date - how to convert it to text 1
Numeric Field Overflow from Excel File to new Table in Access 4
The Numeric Field Overflow error with linked tables 2
Numeric field overflow error on date field 3
Fixing Numeric Overflow 1
Odd Numeric OverFlow Error with MakeTable Query 6

Top