Time/Billing Calculation

[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.

 

[Duane Hookom]

Have you tried creating a totals query that groups by job and sums the
hourly rate * DateDiff("n",StartTime, FinishTime) /60?