Show total record for each field in accesss reports

[rwahdan1978]

Hi,



I have a report that displays number of claims per person per week. Example:


Week: 1

Person Name: Rami
claim
claim
claim

I want here to show Total number of claims: 3

Person Name: Taher
claim
claim
claim
claim
claim
claim

I want here to show Total number of claims: 6

How to do that?

[Welshgasman]

Just use the wizard to create the report and sort/group by Person.
It will do it for you, then you can look to see how it is done.

[June7]

Set up report with Grouping. Will need a group for week and group for person ID or name. Person group header will have person ID and name, detail section will have other data, and then in person group footer, textbox expression: =Count(*)