All branches on the same level

  • Thread starter Thread starter David French
  • Start date Start date
D

David French

My company has 5 branch offices.
Normally if I were to create a report and list the people in each branch i
would group on branch and all the people would be listed for branch
one...then a break for branch 2 and all those people...etc.

This time I'd like to have 5 columns and the listing of people all at the
same level.
I was thinking of a totaling query and getting the listing from that but i'm
not sure how.

If anyone has a good idea of how to get this one done I'd greatly appreciate
it.

Dave French
 
Presumably you have a table with fields such as:
SaleID primary key
BranchID the branch
SalespersonID the sales person
SaleAmount currency

If so, you could create a crosstab query with:
SalespersonID Row Heading Group By
BranchID Column Heading Group By
SaleAmount Value Sum
 
Back
Top