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
Does anyone have a suggestion to improve on this?
Tim