count of subsummary field

[Tom Maxwell]

Hi there,

So many posts talk about how to get a count of related records. I think I have that figured out, but I also want a count of the subsummary field.

I have a contact management database that has a Contacts table and an Activity table. The activity table has a relationship to the contacts table, so that contacts may have one-to-many activities. I have created a report that uses the contact name as the subsummary field, and provides a count for related activities. What I want in addition is a count of the contacts.

The scenario is this - the activity table is a list of the different activities that occur for a contact, along with a date/timestamp, and an activity type. As people work with the database, for each activity they do (make a phone call, email, etc) a row is created in the activity table. The row includes the primary key of the contact. Right now, the report shows a count of each type of activity for each contact, plus a sum of all the activities. I just want in addition a count of contacts, so I can say we talked to x number of contacts during a specific date range. It seems like this should be easy, but I've spent a day on it trying a bunch of stuff and getting no where. Oh please, please, please help.

-Tom

[comment]

See if this helps:

http://www.fmforums.com/forum/showtopic.php?tid/135476/

[Tom Maxwell]

Wow! That totally works. Weird though - does this feel like kind of a weird hack to you? I'm not complaining though! Thank you. I hope my hair grows back.

-Tom

[comment]

It doesn't feel like a weird hack - it IS a weird hack. But it's still the only way I know to get this (other than running a script to do a finger-count).