Filtering Report with between dates

[patrickmcdiver]

I'm basically using the ms template "Timecard" but I need my "Billable Hours by Employee" report to show only the hours accumulated in a 2 week period. Ideally, I would like to be able to select a pay period start date and a pay period end date and then have the report generate with only the hours accumulated in that time period showing up on the report.

How can I accomplish this?

[pbaldy]

You can enter the two dates on a form, and have a query criteria of:

Between Forms!FormName.txtStartDate And Forms!FormName.txtEndDate

[patrickmcdiver]

works beautifully. Thanks

[pbaldy]

Happy to help!