Count dates in a report

[avaz]

Hi all

i wonder if anyone can help me.

I need the total of days in a report but exclude the repeated ones.
So user are working sometimes in different work orders on the same day
but our administration only needs to know the number of days worked in one period of time.

is there a way around ?
i send a jpg with the example i use the =Nz(Count([Date Worked]),0) but that way i get all the entries counted

Thanks
Avaz

 

[Minty]

Basically you need to group on [Date Worked] not the user, that should remove the duplication.

 

[plog]

You can't get this from the data you have on the report. You would need to set up a query to determine it. You would use the datasource that report is built on, bring down just Date_Worked field, make it an aggregate query (click on the Sigma/Summation symbol in the ribbon) and save that query. Then on your report you would do a DCount into that query to determine how many unique days it has.