New Report using Old Query Start and End Date Filter

[Greg2582]

I'm trying to create a report using as existing query, but it hasn't worked
so far.

The report will list the hours spent working on a particular project along
with he Project name, Task Description and TaskID. I'm using the date worked
as the filter, but it's entered as month, day and year.

All iI need is a way to filter the report for each month in the query, not
entire day. Is that possible?

 

[Arvin Meyer [MVP]]

You'll have to Group on a calculated field:

Month([YourDateField])

from your query in a report. Use the Sorting and Grouping menu item and let
the wizard walk you through it.

 

[John W. Vinson]

I'm trying to create a report using as existing query, but it hasn't worked
so far.

The report will list the hours spent working on a particular project along
with he Project name, Task Description and TaskID. I'm using the date worked
as the filter, but it's entered as month, day and year.

All iI need is a way to filter the report for each month in the query, not
entire day. Is that possible?

Yes, probably.

If you would like help doing so post some information, such as the SQL view of
the query. We can't see it from here and do not know how your table is
structured.