Count unique values

M

medirate

I am using Access 2002. I have a report with a field "Physician" as a group
header and "Name" as a group header. Both have group footers.. The detail
has a date field called "DOS".

I want to determine how many times Name has seen Physician, so I need to
count the field DOS. For example:

Kilroy MD
John Smith
10/1/07
10/1/07
10/1/07
10/4/07

From the above, I need the date of service (DOS) to arrive at the number 2.
Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top