"Count" help, please

[Ken Curtis]

I have built a report. It lists the phone/mail contacts made at our Group
Home by various residents. The report is grouped according to the "Name" of
the resident, and each contact made by that resident is listed under that
name. There are multiple names, and multiple entries per name. I need to
show the number of contacts made by an individual resident beside that
resident's name. In other words, if "Bob" had 36 contacts, then I need the
number "36" to show beside Bob's name; if "Sam" had 42 contacts, then ... etc.

I understand that this is likely Data Basing 101 ... but, I'm about a 93 ...
which is great since I have just begun, and everything else seems to be
working (and looking) very well.

While I'm at it ... will I be able to use these numbers to generate graphs
comparing the number of contacts per residents, or should I do that in Exel
where I actually know what I'm doing?

Thanks, folks!
Ken Curtis

 

[Marshall Barton]

I have built a report. It lists the phone/mail contacts made at our Group
Home by various residents. The report is grouped according to the "Name" of
the resident, and each contact made by that resident is listed under that
name. There are multiple names, and multiple entries per name. I need to
show the number of contacts made by an individual resident beside that
resident's name. In other words, if "Bob" had 36 contacts, then I need the
number "36" to show beside Bob's name; if "Sam" had 42 contacts, then ... etc.

I understand that this is likely Data Basing 101 ... but, I'm about a 93 ...
which is great since I have just begun, and everything else seems to be
working (and looking) very well.

While I'm at it ... will I be able to use these numbers to generate graphs
comparing the number of contacts per residents, or should I do that in Exel
where I actually know what I'm doing?

Use a text box on the group header (or footer) with the
expression =Count(*)

 

[Ken Curtis]

Tnank you, Marshall. It worked ... now I'm a 94!
Regards