Report Totaling

[RuthD]

Hello,
I am creating a report and I need to know how to sum the total sessions a person has attended. The information is coming from a series where I track the number of sessions each person has attended. Each week I have to report the numbers and I would like to hand my supervisor these numbers as well as my coworkers.

 

[Bryan]

You didn't provide much to go on, but one thing you can do is construct your report to group by the individual. Then in the section header or footer, add a text box whose Control Source is:

=Sum([[I]YourFieldName[/I]])

This will total YourFieldName for each individual.

 

[Trevor G]

If this has to be date related then add a query first to use date range,

Between Startdate And EndDate from the session date field

If I read this write you would create a query and select the relevant fields like the person and sessions then add a Grouping and change the Sessions grouping into a SUM or Count, that would give you an overall Session based report.

Then you can create the report based on the query.

 

[RuthD]

Thank you all for the help. However, it is no longer needed. I was let go from that particular company this past Monday. I will mark the post as solved. Thank you again for your help.

Ruth

 

[Trevor G]

That is sad news Ruth, I hope you find another placement (job) quickly.