By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,660 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,660 IT Pros & Developers. It's quick & easy.

Distinct Count in Report

P: 69
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.
Dec 15 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
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()
Dec 16 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.