-
[Resolved]Basic Summary
Hi all,
I have one table named as tblSalesman
this table has 2 fields Salesman, GroupID
I can't make a summary field which will count how many Salesman each group.
Yeah, I have try something to get it.
but I can make only a summary field that show like this....
GroupID Howmany Salesman
Group00 1
Group00 2
Group00 3
Group01 1
Group01 2
How to summarize like this
GroupID Howmany Salesman
Group00 3
Group01 2
Thanks a lot for all help:)
-
When you go to select a summary, one of the choices should be 'count'. So, I would just create a subtotal for each salesman using 'count' of salesman as the field to total.
-
Also have it reset on change of group so it will not be a running
sum across groups.
HTH
-
Do i need to make a group of GroupID first?
What should i choose in Summary section, Evaluate section, Reset section?:ehh:
Thanks:)
-
Yes, make a group of GroupID and then do as I posted above and
you will get sums for each group independently of other groups.
-
Thanks RobDog888, Pasvorto :wave: