DCount for Report Level (Access2003)

Topic

New Reply

I need to count Names of the Employees and I am using =Count([EmplNames]) placed into group header.
I figured some names are duplicates I need to display but do not need to count.
I had tried DistinctCount but it is probably not an Access function. I had searched on Internet but it doesn’t seem like there is anything on Report level.
please, advice.
Thanks

Reply | Quote

Replies

Create a query that returns distinct (unique) employee names, e.g.

SELECT DISTINCT EmployeeName FROM tblEmployees

Let’s say you name it qryDistinct

You can then use =DCount(“*”, “qryDistinct”) to display the count of distinct employees.

Reply | Quote

I have this Report that should display non distinct names.
It all goes off a large table already built. I can not have a separate query just for the count.

Like GroupHeader_Activity
Name1—–Activity1
—————Activity2
Name2—–Activity1

GroupFooter_Activity Total Names 2
and I get Total Names 3

Reply | Quote

Why can’t you have a separate query just for the count?

Reply | Quote