Thanks for your reply.
Step by step, here's what I'm trying to do.
1) User enters data onto a form to indicate what schedule they want to work.
2) Create a temporary table (we'll call it tblTemp) that pulls dates from a table (tblWeeks) that match the payroll week selected on the form (I've...