Number calculation longer than field allows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a simple sum query, but I think the sum may be longer than what
the field allows; I am getting something like 8.41641512552E+11. There are
144000 records in the database and the field that I am trying to sum has up
to 12 digits in each record. These are simple numbers - no currency.
 
What's the data type of the field? If it's a Long Integer, then your
suspicion is probably correct.

You may have to convert it to a Double or Single in your query (using CDbl
or CSng) before summing.
 
laralea said:
I am doing a simple sum query, but I think the sum may be longer than what
the field allows; I am getting something like 8.41641512552E+11. There are
144000 records in the database and the field that I am trying to sum has up
to 12 digits in each record. These are simple numbers - no currency.
Click to expand...


If the field can contain 12 digit numbers, then the data
type must be Double or Text. If the field is type Double,
then I think you are probably(?) OK and the answer you got
is accurate (just format it as you want to see it).

If the field is type Text, then I think you may need to use
this kind of expression to sum it:
CStr(Sum(CDec(thefield)))
 
Back
Top