Wages Calculation (1 Viewer)

[Latoya]

If employees rate per hour differ according to Job Title, how can I get Access to calculate employee wages when the total hours worked for a week is summarised in a query and the hourly rate is in a table?

Many thanks in advance.

 

[Pat Hartman]

Use a query to join the employee table to the job title table to obtain the hourly rate. Join that query to the query that sums the hours and multiple the rate times the hours.

 

[Latoya]

Thanks for the tip, but I'm new to access, so a Detailed step would be more useful.

 

[dcx693]

If you're not sure what is meant by "joining tables" in a query, the topic is covered in the Access online help. There is also good info on how to create calculated columns based on other columns in a query.