Wages Calculation

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

 

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