We have a table in Access with the following fields. Date, Week Code, Employee Name, Position, Shift, Hours, Rate. We want to create a query in Access to calculate regular salary and overtime salary (which is defined at 1.5 the Rate for any hours worked over 40 during the week. Can you please help us make this query?