Group Totals for a category/project

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I provide totals for project time?
Data:
Date1 Project1 3
Date1 Project2 1
Date1 Project3 4
Date2 Project2 8
Date3 Project2 3
Date3 Project3 9
Need report to look like:
Detail as above with a total hours of 28, and showing hours for each project -
Project1 3
Project2 12
Project3 13
Is there a way to do this without a sub-report? (Access 2000 2002)
 
create an SQL with group by, that add the houres

SELECT ProjectFieldName, Sum(Houres) AS SumOfHoures
FROM MyTable
GROUP BY ProjectFieldName

Bound the report to that query, and the create two fields in the detail
section of the report, and bound this two fields to the query you created.
 
Back
Top