Problem with a calculation in a query

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

Guest

I have a field in a query that shows the percentage of ownership of a condo there are 291 records. e.g

Name Unit SfCondoUnit
Smith 8 0.1
Jones 8 0.0
Love 8 0.1

From that query I have made another query to calculate (Sum Of CONDOUNITS: Sum(PERCENTAGES.SfCondoUnits) all of the ownership together, the total should show 29, but instead it shows 29.000000000001. I dont know why it is doing this? Is there a rounding command? I have had this problem also when I calculate the report. I am completly at a loss
 
Jane,

This is happening because the way computers store numbers means that
certain values simply can't be reppresented precisely. And Yes, there
is a Round function. Try...
Sum Of CONDOUNITS: Round(Sum(PERCENTAGES.SfCondoUnits))

- Steve Schapel, Microsoft Access MVP
 
Back
Top