Count Unique Function

[Cleung]

Is there any functions that I can use in a report to count the unique value in a field. e.g. there are so many records of the same day, I just want to count it once.

Thanks!

 

[Cleung]

The report has already used a query to bring out the details, that means every records even it is the same day. In the page footer I need to count the number of unique date. I think it's impossible to have two separate queries in the same report. The other way I can think of is to use subreport. It would be simplier if a function can do the job.

 

[IMO]

Create a query that counts certain Values and use DLookup in the report, see my example Here

IMO

 

[Rich]

Add a group level and count the groups