Calculating UPH in MS Access

tsmcneill

New Member

Join Date: Sep 2010

Posts: 1

21st Sep 2010

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

« MS Queries in Excel 2000 now on 2007 | explorer.exe corrupted »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculating Age in Access	forest8	Microsoft Access Getting Started	4	9th Mar 2010 03:56 AM
I need help calculating a sum in Access	=?Utf-8?B?Q2FsY3VsYXRpbmcgQmFsYW5jZXMgaW4gQWNjZXNz	Microsoft Access Getting Started	2	14th Mar 2005 07:38 PM
Re: Access 2003 form designed in Access 2000 hung up on calculating	Allen Browne	Microsoft Access Forms	0	17th Aug 2004 04:43 PM
Calculating in Access	Diana	Microsoft Access Getting Started	1	25th Jun 2004 04:17 AM
Calculating Age In Access - New Problem	Ray	Microsoft Access Queries	4	18th Dec 2003 09:32 PM