Summing in reports

[rcollins]

Here we are back on the report that I was trying to sum for the three different criteria. Now what they would like to see is a total for each of the criteria at the end of the report. Here is what my report looks like:

Client Name                               Total time: 5
      Line Staff                                    3
      Senior Therapist                              1
      Lead Therapist                                1
Client Name                               Total time: 3
      Line Staff                                    2
      Senior Therapist                              1
 
 

At the end, we would like to see:

                                                 Total Time per Employee
      Line Staff                                    5
      Senior Therapist                              2
      Lead Therapist                                1
 

Any help would be great

[Rabbit]

Here we are back on the report that I was trying to sum for the three different criteria. Now what they would like to see is a total for each of the criteria at the end of the report. Here is what my report looks like:

Client Name                               Total time: 5
      Line Staff                                    3
      Senior Therapist                              1
      Lead Therapist                                1
Client Name                               Total time: 3
      Line Staff                                    2
      Senior Therapist                              1
 
 

At the end, we would like to see:

                                                 Total Time per Employee
      Line Staff                                    5
      Senior Therapist                              2
      Lead Therapist                                1
 

Any help would be great

=DCount("*", "[Table/Query Name]", "[Field Name] = 'Line Staff'")

Lather, Rinse, Repeat.

[rcollins]

=DCount("*","[qryMain]","[Title] = '1 Line Staff/Peggy James'")
 

Shouldn't this be DSum? Even then, doesn't work. Where does this go? I thought it would go in the report footer.

[Rabbit]

DSum or DCount? It depends on how your table/query is set up. What are the fields and types of data your table/query holds?

[rcollins]

What we are doing is keeping track of the time employees have contact with clients. Time is in units, where each unit is 15 minutes. The fileds that I am using for calculations are Title, the employee spending the time with the client which is text, and Time, which is spent with the clients, which is number. We also use the client id and name on the report. The report is in alpha by client, then divided into which employee (Title) spent time with the client. We run this report every month. The only detail we need from this report is the sum of the time that each employee spent with the client. Now, at the bottom of the report, we want it to sum by employee, so we can see who much time each employee spent with total clients for the month. I hope this is enough info

[NeoPa]

In a report header you can use =Sum([ControlName]) to produce sums of the values within a particular group or even across the whole report.
We would need some more details of the fields you're working with to go into more detail.

[rcollins]

What more details do you want?

[NeoPa]

What more details do you want?

A strange question considering you've supplied none as yet.

• Names of controls.
• MetaData of your tables.
• RecordSource of your report.
• Grouping of your report.
• What you want totalled and how (Remember you can total by Groups as well as overall).