Access Calculating UPH in MS Access

T

tsmcneill

Joined
Sep 21, 2010
Messages
1
Reaction score
0
I am building a report in MS Access 2007 and it needs to calculate "Units Per Hour" for production users. The calculation is based on three fields... [TotalUnits] , [StartTime] and [EndTime]. The formula that I have tried and does not give me the correct result is... "[TotalUnits]/[EndTime]-[StartTime]".
Does anyone have a suggestion to improve on this?

Tim
 

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

Similar Threads

Problem inserting time values from Access into SQL Server 5
Calculated fields in Access 2
Calculating a Date 1
Access Access 2007 - Help - Please Read.... 0
Outlook Calendar Reporting via MS Access 1
Access HELP NEEDED: MS ACCESS OPTION GROUP 0
Access MS Access 2007: Capture parameter value and pass it to a form's field 0
Query/Report set up confusion 4

Top