Creating a report to display Data on a monthly or quarterly basis easy for end user to filter

[halabis]

I am trying to create a report that will take a data set and display either quarterly (to date) or monthly hours worked by an employee.

The data fields being pulled are "Employee Name" "Data Period" (Stored in the format "August 2014") and "Hours Worked"

I currently have it set up so that the report pulls from a query of these three values, and then displays The employee name and the sum total of hours worked by them. I need it to display the sum total they have worked for the selected quarter to date. That is if I run the report and want Q3 data it will give me the sum of July, August, and September hours worked for each employee. If I run the report for Q4 in December it will give me the sum total of hours worked for each employee for October and November (since December data would not be entered yet).

Is there a way I can set Access to only pull the selected quarter to date with a filter?

[ranman256]

I have a 'reports' form, on it is txtSTartDate, and txtEndDate. These are autofilled by clicking either the month, year, Qtr.
(calendar dates and fiscal dates)
the logic fills in the dates, the queries run off the form txtDates.

[GinaFlan]

So do those "selections" insert the data into a report that is already "created" or "there" or is a completely new report generated? I am trying to do something similar but I need to the data to go into a Report already set up with conditional formatting and hiding duplicates

[halabis]

That looks excellent and, pardon my ignorance, but how do I do that?

I have a 'reports' form, on it is txtSTartDate, and txtEndDate. These are autofilled by clicking either the month, year, Qtr.
(calendar dates and fiscal dates)
the logic fills in the dates, the queries run off the form txtDates.