[Resolved]Basic Summary

[naruponk]

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

[Pasvorto]

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.

[RobDog888]

Also have it reset on change of group so it will not be a running
sum across groups.

HTH

[naruponk]

Do i need to make a group of GroupID first?


What should i choose in Summary section, Evaluate section, Reset section?

Thanks

[RobDog888]

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.

[naruponk]

Thanks RobDog888, Pasvorto