Finding Count Distinct in a Sub Set

M

maic15

Active Member
Joined
Nov 17, 2004
Messages
313
I'm trying to write a query that counts distinct PracticeMgr. Please see result below.



Current State


PracticeMgr RptIncentiveKey strDepartmentNumber
Ann Marie Lahaie IG34 30604
Ann Marie Lahaie IG34 30608
Ann Marie Lahaie IG34 30610
Ann Marie Lahaie IG34 30611
Ann Marie Lahaie IG34 30615
Ann Marie Lahaie IG34 30619
Lillian Sonnenberg IG34 30609


Result


PracticeMgr RptIncentiveKey
1 IG34
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Sort by date Sort by votes
Hi
Try using a Select Query, Click View -> Totals, group by Practice Manager.
HTH, Andrew. :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Counting a table by groups an item is within
Replies
3
Views
134
alansidman
A
E
  • Question
Can anyone help me get my VBA code working? I have spent tons of time but can't quite fix it.
Replies
3
Views
3K
profray
P
S
  • Question
Find unique Value and Count
2
Replies
12
Views
1K
vishal0589
V
A
  • Question
Replacing a formula with it's result with vba
2
Replies
17
Views
531
andy72685
A
A
  • Question
Attempting to create summary records in a table for large number of tables
Replies
5
Views
1K
Atroxell
A

Forum statistics

Threads
1,215,842
Messages
6,127,225
Members
449,371
Latest member
strawberrish

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top