Calculations

[Rallie]

I am trying to simplify the process of dealing with External Labour. I have
set up my DB and am now trying to get my queries and reports to work.

I have created the following tables:
Employer
Employer & Trade (Links to Employer)
Employee Details (which links back to the employer and trade).
Timesheet entry (Which Links back to the Employee Details)

I want to write a query/report that allows me to list all the hours and jobs
that an individual employee worked on for a weekending, which I have done but
now I just need it to show the value that the Contractor is allowed to
invoice me for.

In my report I have done a sum on all the Different Hours becuase employee's
can work on 3 different rates and then different employees have different
rates.

I am happy to have the sum of the 3 different hour times and them multiple
this by the rate that that particual employee is on. Plus a total for these
different categories.

Cheers,

 

[Lord Kelvan]

where is the contractor stored and how do you note he is a contractor

as for rates how do you know which rate is which do you have rate1
rate2 rate3 or $10 $15 $20

Regards
Kelvan