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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
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
257
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
601
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,221,848
Messages
6,162,419
Members
451,764
Latest member
giannip

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