Need Help with an Access Calculation in a Report

[jlf]

Need serious help with a calculation. The fields are based on a query that has linked many different tables. The calculation I currently have is:

=sum([QtyProduced])/(([runtime]+[downtime])*(Piecesnum]))

It is giving a calculated outcome, but an incorrect one. I am basically trying to get the QtyProduced to divide into the combined runtime+downtim e*piecesnum to get a sum of efficiency. I've tried many different combinations of this calculation, but have had not luck. Any suggestions would be truly appreciated.
JLF

[wlc04]

Try this:

=sum(([QtyProduced]/([runtime]+[downtime]*[Piecesnum]))

[jlf]

Try this:

=sum(([QtyProduced]/([runtime]+[downtime]*[Piecesnum]))

Wendy,

Thank you, this worked great.
jlf

[jlf]

Resolution for anyone interested

=Sum([qtyproduced])/((Sum([qtyruntime]+[timedown])*[piecesperhour]))

The suggestion from Wendy was actually still giving me incorrect data, but still appreciate the suggestion. The above formula fixed the issue completely.

[wlc04]

OOPS!! Sorry about missing the sum, but I'm glad you figured it out. :o

[jlf]

OOPS!! Sorry about missing the sum, but I'm glad you figured it out. :o

No worries.....you 're great. JLF