I want a count of unduplicated clients on a Monthly/Quartelry/Yearly search

[qmrp10]

I'm new to Access. It is obviously a very powerful database program I've developed a data base of my agency's service purchases for a variety of clients. I have to generate a report totaling the monthly purchases and counting the number of unduplicated clients. We make multiple purchases for clients monthly. There must be a feature on this program that will sort through the client ID Numbers and count them (rejecting duplicates) in that one month or quarter or year. Can someone tell me how to do that? I've been exporting to excel, sorting by client ID and then counting each new ID number. It is getting tedious, especially when I know that if I just asked someone how to do this, I know someone could walk me through that process. Thanks in advance for any help or light you may be able to shed on my question.

[orange]

The general query is as follows. It identifies the unique ClientIDs

Select DISTINCT ClientID FROM YourTableNameGoesHere

Readers need more info about your database and tables to offer a more focused answer

[qmrp10]

I included a sample of the data stored in the data file named "Service Purchase". I'm not quite sure where to type the string you listed above. I tried to enter it in the query wizard, but it will not accept that string.

Service ID	Service Code	Service Start	Entry Date	Service End	Service Cost	Client ID	Provider ID
255	1800	01-Nov-13	14-Mar-14	01-Nov-13	$46.20	10	21
292	1835	01-Dec-13	14-Mar-14	31-Dec-13	$1,571.70	16	3
307	1620	01-Jan-14	14-Mar-14	31-Jan-14	$866.25	10	8
291	6077	01-Jan-14	14-Mar-14	31-Jan-14	$6,541.00	15	2
314	4620	01-Jan-14	14-Mar-14	31-Jan-14	$616.25	16	8
305	4834	01-Jan-14	14-Mar-14	31-Jan-14	$8,573.98	18	1
298	1860	01-Jan-14	14-Mar-14	21-Jan-14	$3,906.00	19	25
315	4620	01-Jan-14	14-Mar-14	31-Jan-14	$977.50	30	8