R
Robert Blair via AccessMonster.com
Using Access 2000. 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. So far, I've
managed to create the query to pull in all of the timecards for each
project, sort them by date and generate the report, broken down by
quarters, and print "Totals Billable Hours for Quarter", but the subtotal
printed on the report is only for the first timecard of the quarter, not
the total of all hours in the quarter.
Any help is appreciated.
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. So far, I've
managed to create the query to pull in all of the timecards for each
project, sort them by date and generate the report, broken down by
quarters, and print "Totals Billable Hours for Quarter", but the subtotal
printed on the report is only for the first timecard of the quarter, not
the total of all hours in the quarter.
Any help is appreciated.