Query not calculating totals

[Access Virgin]

I have a query that is retrieving figures from a table for two column headings. The query is then used as the record source for a report. On the report I have used 2 text boxes to sum the lists of figures. It works out 2 totals but they are incorrect. When I use the sum function in the query it again works out the totals to be the incorrect values calculated on the report.

When I analyze the report with Excel and add the figures manually I get 2 different totals, one that is a few pence greater and one that is a few pence less.

The strange thing is that when I add both the totals calculated on the report and the totals calculated with Excel they are the same.

Anyone come across this problem before where Access isnt calculating totals correctly?

 

[AncientOne]

It sounds to me as if this might be a rounding error. What is the number format for all the number fields involved in the calculations?

 

[Pat Hartman]

For a good explaination of this problem, read the article titled "When Access Math Doesn't Add up" at www.fmsinc.com. There are a number of articles worth reading at that site.

 

[Access Virgin]

They are currencies with the decimal places set to 2

 

[noob23]

Virgin,

I'm trying to create Access queries for calculating formulas as well. I'm having trouble. Can I see your queries? They would probably help me a lot. Thanks!