"Count" help, please

  • Thread starter Thread starter Ken Curtis
  • Start date Start date
K

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
 
Ken said:
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?
Click to expand...

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