I. Create a query:

1. Create a calculation query.
2. On the Criteria tab, select Calculations, Employee period end date [between] [Date 1] and [Date 2].
3. Click OK.
4. On the Output tab select:

Calculations> Calculation Batch ID, Employee ID,  and Employee full name
Pay Types> Pay type ID, Pay type description, Hours, Rate

5. Select the Results tab.
6. Click Save.
7. On the Results tab, click the Export to Excel button above the results grid and save the export file.
8. Save and close the query.