Group summary?

[tropez67]

Greetings all, I am trying to get a count of all the people that are admitted to the same program more than once. I thought of a distinctcount, and that gets me the number of programs the person is in, but how can I compare the records to tell if it was the same program?

Another similar question is I need to get a count of the number of times a person was admitted to a list of programs assigned to a department.

If anyone could help me I would appreciate it.

Thank you

[msmnithya]

hi,
just write a formula which field is going to count.

[tropez67]

I ended up doing a combination of running totals which got me to the numbers eventually, just not quite as easy as I hoped it would be.