Sum query returns wrong results on a large table

M

matos.rodrigues

Hi
I have a 1.5 million records table. When I do a sum query on a double
ou currency numeric field, query returns zero or some other wrong
result. If I sum a fewer number of records, say 100 hundreds then sum
is done alright. What shall I do to sum all records?
Thanks.
A Matos Rodrigues
 
P

PvdG42

Hi
I have a 1.5 million records table. When I do a sum query on a double
ou currency numeric field, query returns zero or some other wrong
result. If I sum a fewer number of records, say 100 hundreds then sum
is done alright. What shall I do to sum all records?
Thanks.
A Matos Rodrigues

Sounds like overflow. You know the values being summed. Is overflow a
possibility?
 

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

Top