Distinct Count in Report

[KMEscherich]

Using Access 2003

Hi there, am wondering if someone can please help me with retrieving DISTINCT COUNT of a type field. I can get a total, which in this example would = 9, but I also need to know Unique Types = 3. I sure hope someone can help me with this. The data will be grouped by DEPT.


DEPT 1
Type 1 / Date . . .
Type 1 / Date . . .

DEPT 2
Type 1 / Date . . .
Type 2 / Date . . .

DEPT 3
Type 1 / Date . . .
Type 2 / Date . . .
Type 3 / Date . . .

DEPT 4
Type 2 / Date . . .
Type 2 / Date . . .

Thank you VERY MUCH for your assistance.

[puppydogbuddy]

create a textbox and bind it to an expression using ECount(), a UDF by Allen Browne that extends Access's built-in DCount function to allow the count of Distinct values.

Microsoft Access tips: Extended DCount()