Report Calculations

[MizTEcK]

HI, I currently have a table of aorund 300 entries with one of the columns filled as hours spent doing something.

I'd like to create a report, in which it'll look something like this

activity1---------------------hours
activity1---------------------hours
activity1---------------------hours
activity1---------------------hours
total---------------------total hours for activity1
activity2---------------------hours
activity2---------------------hours
activity3---------------------hours
total---------------------total hours for activity2

something like that, but i can't find the option that allows me to add specific hours together as well as a way to insert the total hours in between the list of reports (the sum isn't a column or field in the original table, i'd like to create it specifically on the report)

does anyone know how to do this?

if clarifications are needed please lemme know

 

[statsman]

There are a variety of methods of doing this. The easiest way is to use the summary option in the report creation wizard.

When using the wizard to create the report, select acivity1 and activity2 to make summaries. Click on the summary options and select "add" or "total" (depending on the version of Access you are using).

 

[VanRoekel.Clint]

Group ON

Click on the "group on" icon in the report edit screen.
Select the Field/Expression that contains the activity 1, 2 and 3 information. Select Yes for group footer.
Insert a field in the group footer section that sums the hours.

You will need to sort on this field.

I hope that this helps......

 

[aneats]

i'm having sort of the same problem. My report represents particulars of a meeting; who has attended and how long it has lasted. I have 4 fields:
Meeting (stored in Meeting Header)
Time_Taken (stored in Time_Taken Header)
Date_of_Meeting (stored in Detail)
Staff (stored in Detail)

The report displays the name of the meeting, the date it took place, staff present, and the length of each meeting.
My problem is, i want to display in the report footer, the total time taken in meetings, but my results return the following:

meeting 1, 12/12/2004, staff:claire, julie, tom, duration:1 hour
meeting 2, 01/01/2005, staff:tom, dick, harry, duration: 2 hours

meetings between 12/12/2004 and 01/01/2005 took 9 hours

the results SHOULD show:
meetings between 12/12/2004 and 01/01/2005 took 3 hours

Hope someone can help.