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![]()




Reply With Quote