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?
 
Back
Top