Access 2000 Numeric Field Overflow

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
It could be that the datatype is set to integer, try make it a double (the
numerical field that is)

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

Absolutely. Pick the one you think is appropriate range wise then...

Maurice
 
You must log in or register to reply here.

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
Any link between malware and scam calls? 2
Numeric Field Overflow from Excel File to new Table in Access 4
The Numeric Field Overflow error with linked tables 2
Odd Numeric OverFlow Error with MakeTable Query 6
Numeric field overflow error on date field 3

Back
Top