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?

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?

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.

They are currencies with the decimal places set to 2

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!