Counting Dates

[JenBouchard]

Hello.



I have a database where we want to know the number of days a particular service was received.

In the table, a date is entered, a client ID is entered and if received, services A, B, C or D are checked.

I was able to figure out how to sum the services (either A, B, C, or D) when prompted for a particular client ID between two dates. The tricky part has been to sum the (unique) dates a service (either A, B, C, or D) has been received. In other words, we know how many times Service A was provided to Client123, but how many days of service did Client123 receive?

Is there a way to use the sum function on a report to do this?

Forgive me if I'm not asking this the right way; my degree is in research (and I have taught myself database design on my own) so I appreciate any help you can offer.

[ConneXionLost]

Hi JenBouchard,

A basic approach for this is to use two queries. The first would query the table for ClientID and ServiceDate using the "Totals" (Summation Icon) to group the fields. The second would query the first query, again with "Totals", for ClientID as a Group By and again as a Count. The count will give you the number of days your client received service.

Cheers,