Using Count(*)in report with date parameters

[carpstar]

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

 

[Sohaila Taravati]

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

 

[carpstar]

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

 

[carpstar]

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.

 

[carpstar]

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