Using Count(*)in report with date parameters

carpstar

Registered User.
Local time
Today, 03:34
Joined
Apr 5, 2002
Messages
30
I have a report that sums work hours for each employee in a given date range. I added a text box to count the Name field. Like this
=Count(Name). But even though each employees name only appears once on the report, the Count(Name) counts all records for each employee in the date range. How do I get a Distinct Count for the Name field. I tried Distinctcount Uniquecount Dcount. But to no avail. should I not be trying this in the control source property of the text box. Could someone help with this.

Rory
 
Go to your grouping and sorting of your data in the design of your reprot and make a header or footer for your name filed and put your calculations there. I think that should solve your problem:)
 
Thanks Sohaila,

But I still can't do what I need. I'm not good with VB code at all. Report is pulled up by date range (A given week) so JAMES may have 5 records that are summed on the report which only shows the summary (no datails)
When I put a textbox in the header or footer with Count(*) in record source it will count JAMES as 5 but I need it to count as 1.
I not only need to know the correct code (syntax) but the place to put the code to make this work.

Again Thanks to All
 
I have checked the archive for distinct count and it seems to me that no one has given a clear answer on returning a distinct or unique count. With some of the other problems I got help with on this forum I'm sure someone can explain this in laymens terms.

Thanks again for assisting us less talented access users.
 
Viola
I got it to work!!!
I put text box in details section of report named it RecordCount and put record source =1 and
visible as no. Then put textbox in footer and record source =RecordCount.

Thanks
 

Users who are viewing this thread

Back
Top Bottom