Count Unique Records, only

[froggiebeckie]

In a report, I have a textbox to show the number of employees in the report.
I use this formula :
=Count([last name])
Sometimes the same person has multiple entries, so the count is wrong.
How can I show only the number of different employees and ignore the duplicate names?


Thanks

 

[pr2-eugin]

Create a simple Query that will have the Count of Last name based on the table, like..

SELECT Count(lastName) As CountOfLastName
FROM theTableName
GROUP BY lastName;

Save the Query by giving it a name, then use the Query value in the Report..

= DCount("CountOfLastName", "theNameOfTheQuery")

EDIT: Edited Code.

 

[froggiebeckie]

Cool Beans!!
Thanks so much.

 

[pr2-eugin]

Please look at the UPDATE Code.. You need DCount, not DLookUp. Just tested it..