By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Need Help with an Access Calculation in a Report

P: 12
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+downtime*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
May 17 '06 #1
Share this Question
Share on Google+
1 Reply


P: 12
jlf
=Sum([qtyproduced])/((Sum([qtyruntime]+[timedown])*[piecesperhour]))

Works great.
jlf
May 18 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.