DCount to find unique values?

[gojets1721]

Hi so I've got a database of complaints that employees have submitted. One of the fields is the "Employee" field and this lists the name of the employee who submitted the complaint.

In a report, I'm trying to find a way for it to display the total number of unique employees that have a submitted a complaint. Is there a way to use dcount or some other function to do that?

Thx

 

[MajP]

You can make a Group By query of the complaints and return just the Employee field and the count of complainID or some other field.

Then that query would return
John Smith 10
Mike Brown 25

Create Relationships in Access - Instructions and Video Lesson

Create Relationships in Access: Instructions & a video on how to create relationships, or table joins, in the Relationships window in Access.

www.teachucomp.com

 

[theDBguy]

Hi. You can also take a look at this.

Microsoft Access tips: Extended DCount()

Code to count the number of records in a table/query in Microsoft Access, with the option to count the number of distinct values. A replacement for DCount().

allenbrowne.com

 

[conception_native_0123]

In a report, I'm trying to find a way for it to display the total number of unique employees that have a submitted a complaint. Is there a way to use dcount or some other function to do that?

another alternative to MAJp's suggestion that might be easier to follow is to use the distinct keyword on the employee field and put dcount() of the field in the 2nd field of the query. then just report on one of those records. or, create a report by hand and use dcount() in a stand-alone manner inside a control of your choice. that should work too.

 

[Pat Hartman]

Using Distinct for this purpose could result in missing items. Use a totals query with group by "Employee" and Count(*) to count complaints.