I have a table where I enter daily production totals for each employee. I want to run a query on an employee and get totals from just the production days in the employee's rating period. The daily production table is set up as:
EmployeeName
EntryDate (a date)
Hours
Volume
The employee table is set up as
Employee Name
RatingPeriodStarts (a date)
RatingPeriodEnds (a date)
The production table is linked to the employee table by the employee name. I want to query the production table just for the entries that are within the employees rating period. Do I enter that under criteria? and if so, what expression do I use.
Thanks.