I have a query where I (if I simply it) have three fields. Points, Number and a computed field (Points x Number /40).
If Points is 6 and Number is 1, the computed field is 0.15.
I have 5 rows with the same values.
I then want to summarize these 0.15 values and creates a new query where I group the rows and try to get the sum of the 0.15 values. In all normal mathematics 5 x 0,15 is 0,75, but in the query the sum is 0,5.
To test I changed the computed field in the first query to (Points x Numbers /4) and then I am getting 1.5 instead. When Access summarizes this, it delivers the right answer: 5x1.5 = 7.5
So the question is – can not Access compute values below zero?
The properties for all fields are Default and 3 decimals, and I have tested several other properties, but no avail.
I am doing something wrong, but what?? (I am using Access 2003.)
Grateful for any tip, solution or suggestion.
regards / Bengt C