Display Quarterly Totals on Multi-year Report

[Dragunsfyre]

The data for the report is in one table - tblTimeCards. The critical fields are [ProjectID], [WorkDate], [Description] and [BillableHours]. For audit purposes, I need to create a report for each [ProjectID] which will display the [WorkDate], [Description] and [BillableHours] in chronological order, with sub-totals for billable hours by quarter and total billable hours for the entire project. The projects can span several years.

I'm having difficulty getting the subtotals by quarter. Any help is appreciated.

 

[ZmrAbdulla]

Create a quarterly query and create a report with that query withe quarterly groupings.

________________________________________
Zameer Abdulla
Visit Me
A child may not be able to lift too much.
But it can certainly hold a marriage together