Question about Totals in Crosstabs

[miracleman]

I'm creating an attendance report using crosstabs, the dates in the table are the values in the AttendanceDate field, and the values are the hours worked that date. Now I would like to add a new column that will add the hours worked in all dates for a person to show the total hours worked for that person. Any ideas?


Full Name ProgramName 10/22/2007 10/25/2007 Total Hours Worked
Person Name 1 Program Name 1 2 2 ?
Person Name 2 Program name 1 2 2 ?

 

[namliam]

To add totals simply do a sum or count on your desired values and put them as row header, this will add your totals