How do I fix an incorrect result with division in a report in Acc.

G

Guest

I'm trying to calculate GPA for students on a report. The report formula
seems to be adding correctly but when I divide by 8, I get a result that is
off by about 2 hundredths. If I divide by 5, it works. What am I missing?
 
D

Duane Hookom

"What are you missing?" How about telling us a little about your table
structure, data types, sample records, desired results, calculation
expressions, and current results?
 
G

Guest

The table holds a record for student name, school year quarter, letter grade.
There is a macro that converts an A to 4 points, etc. The report seems to
be the problem. I put in a =Sum([Grade1]) to check the addition first of all
and it's adding correctly. The other formula, =Sum([Grade1]/8) doesn't
divide correctly but =Sum([Grade1]/5) does. For example the sum of one stud
grades is 28.5. Division by 5 gives me 5.7 which is correct. Division by 8
gives me 3.54 when it should be 3.56. That's where I'm stuck.
 
D

Duane Hookom

You provided about half the information I requested so this is a WAG: What
happens if you try:
=Sum(Grade1)/8
I have never seen or heard about an instance where an expression like this
in a group or report footer did not return an accurate value. Sometimes the
value may display off due to rounding.

--
Duane Hookom
MS Access MVP
--

jennrobb said:
The table holds a record for student name, school year quarter, letter
grade.
There is a macro that converts an A to 4 points, etc. The report seems to
be the problem. I put in a =Sum([Grade1]) to check the addition first of
all
and it's adding correctly. The other formula, =Sum([Grade1]/8) doesn't
divide correctly but =Sum([Grade1]/5) does. For example the sum of one
stud
grades is 28.5. Division by 5 gives me 5.7 which is correct. Division by
8
gives me 3.54 when it should be 3.56. That's where I'm stuck.

Duane Hookom said:
"What are you missing?" How about telling us a little about your table
structure, data types, sample records, desired results, calculation
expressions, and current results?
 

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