Brad-
As long as the number of minutes is just a number like a Long Integer, you should be able to do:
QtyPerHour: (TotalQuantity / TotalMinutes) * 60
If you're storing minutes in a Date/Time variable, it gets a bit more complicated because minutes are stored in the value as a fraction of a day. You would need:
QtyPerHour: TotalQuantity / (TotalMinutes * 24)
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of bradgriffis@yahoo.com
Sent: Tuesday, November 12, 2013 4:00 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Quantity per hour calculaton
Hello, how do I calculate the quantity per hour in a database that records the total quantity and total minutes for a specific task? I want the value to appear in a report. I use Access 2007. Thanks.
Brad
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar