Access 2010 Report

[Kelly Napier]

Hi
I have a daily log query whereby a number of clients can access our service more than once in a week. I want to count the number of clients that visit in a week rather than the number of client contacts in a week - I want to do this in a report (attached to the query so that I can use the date parameters).

I also just want to put an unbound text box on the report with a line like
=Count([Client ID]) but with no duplicates counted.

So I am looking for a simple way to just count the number of clients without counting them more than once each.... can someone please help?

Kelly

 

[plog]

Can you post 2 sets of data: A-sample data from your table (include table and field names) and then B-what results you expect based on the initial sample data (A). Use this format for posting:

TableNameHere
Field1Name, Field2Name, Field3Name...
David, 13, 3/9/2010
Larry, 35, 4/4/2008
Pete, 91, 5/7/2007

 

[Kelly Napier]

Thank you for replying - however, I am self taught with Access - so I don't understand where I am to post this. Is there not a simple formula that I can put into an unbound text field on the report?

Thanks again

 

[plog]

Post what I've requested in your response, format it like I demonstrated.

No, from my initial understanding, it doesn't seem like you can accomplish this with a few characters in a control. It's probably going to take a query and then some characters that you put in a control. But to be sure, I'm going to need that data I requested.

 

[Kelly Napier]

Table Name: Daily Log Sheet
Field 1: Client ID
Field 2: First Name
Field 3: Surname

 

[plog]

Not even close. Please see my first post. I want sample data, not just names.

 

[Kelly Napier]

I feel as though you're getting upset with me, so I think I'll leave it an source further help.

 

[Cotty42]

Create an SQL query to collect the data for your report. Something like:

SELECT [Daily Log Sheet].[Client ID], [Daily Log Sheet].[First Name], [Daily Log Sheet].Surname, Count([Daily Log Sheet].[Client ID]) AS [CountOfClientID]
FROM [Daily Log Sheet]
GROUP BY [Daily Log Sheet].[Client ID];

This will give you:
Client ID - First Name - Surname - No. of recors in Daily Log Sheet

Hope this helps

Dave