simple arithmetic not working way I'd expect

[quaddawg via AccessMonster.com]

I am trying to summarize data on two reports.
On one report I have the following for a calculated "percent mastery" control
for each student:

=Round(Nz([Colors])+Nz([Letters])+Nz([NumbersCounting])+Nz([Sizes])+Nz(
[Comparisons])_ +Nz([Shapes])/88*100),

with 88 being the max possible score. Things seem to be working fine with
this formula.

However, when I tried to use the same logic for a larger number of subtests I
ended up with bizarre results well over a 100 percent. I've quadruple
checked the underlying data, the appropriate sums of the tests and that I've
written everything in the same way as the first time:
=Round(Nz([Colors])+Nz([Letters])+Nz([NumbersCounting])+Nz([Sizes])+Nz(
[Comparisons])+Nz([Shapes])_
+Nz([DirectionPosition])/153*100).
As soon as I added the next subtest, [DirectionPosition] (65 points), I got
figures over 100.

All fields listed above are stored as Number, Double.
Does this have something to do with how Access stores numbers, or am I
missing something very obvious and elementary that my sleep deprived brain
can't see? Why would it work in the first instance and not in the second?
How can I best accomplish this?

 

[Bill Edwards]

Maybe operator precedence?

=Round(
(
(Nz([Colors])+Nz([Letters])+Nz([NumbersCounting])+Nz([Sizes])
+Nz([Comparisons]) +Nz([Shapes]))
/88
)*100,2)

 

[quaddawg via AccessMonster.com]

Thank you, it worked. I'll take a closer look and learn when I have a chance
to catch my breath.
Lawton

Maybe operator precedence?

=Round(
(
(Nz([Colors])+Nz([Letters])+Nz([NumbersCounting])+Nz([Sizes])
+Nz([Comparisons]) +Nz([Shapes]))
/88
)*100,2)

I am trying to summarize data on two reports.
On one report I have the following for a calculated "percent mastery"

[quoted text clipped - 25 lines]

can't see? Why would it work in the first instance and not in the second?
How can I best accomplish this?