[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: