Time/Billing Calculation

  • Thread starter Thread starter Kirsty via AccessMonster.com
  • Start date Start date
K

Kirsty via AccessMonster.com

Hoping someone can help.
I have three table 1) award table containing award hourly rates 2) employee
table containing employee details with their current award 3) billing table
detailing each job undertaken by each employee and start and finish times
(in hh:mm).

I need to create a query which calculates the cost of each job in the
Billing Table.

I am new to Access (2002) and can't for the life of me work it out!

I am grateful to anyone that can help.
 
Have you tried creating a totals query that groups by job and sums the
hourly rate * DateDiff("n",StartTime, FinishTime) /60?
 
Back
Top