I need to query records in one table that have a date that is after a date in another

[goakley]

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.

[pbaldy]

If there is only one record for an employee in the employee table, you should be able to add both tables to a new query and join them on the employee field (name is a bad choice for a key field given the possibility of duplication). Then in the criteria of the EntryDate field try:

Between RatingPeriodStarts And RatingPeriodEnds