Could have a simple answer, but I haven't a clue!

[lundygras]

I have a group of customers in a database (aprox 600) and a small group (<10) of people who service those customers.
I am able to run a report for each service person which lists all the necessary customer info for any particular day and gives me a total on each report of the number of customers being serviced.
What I want to do is generate 1 report that lists each service person and the total customers for that person. I would then like to have the total customers being serviced also on that report.
I think part of my problem stems from not knowing enough about access when I started. All my customer info is in 1 table. Several of my service people are handling 2 groups of customers (distinction between groups is geographical). I over came that issue by combining my customer groups when I created my queries for each service person.
I feel like I'm too far in to vevamp the whole system as I have forms created to input data and print reports with the help of macros.
I did figure out how to create a report that has the customer totals, but the report shows those totals by geographic area and not necessarily by service person. The commands I used to get this are in header area of the report. Because of this it seems that I can't get a customer total.
Any suggestions would be helpful. Thanks!

 

[jdraw]

How many tables do you have? What do they represent?
Can a customer be served by more than 1 service person?
What does group mean to you?

 

[lundygras]

I only have 1 table with customer info ie. name, address, phone, number, area. A customer will only ever have 1 service person. I guess what I would call a group is X amount of customers in one area. When I first started the table I had 1 service person for each area, but as things developed some service persons have 2 areas. When I realized this would create a problem I didn't know how to fix it without messing up other things I had done.

 

[lundygras]

Thanks for the advice Pat, but I used =count([area]) in the header area of the report to get just 1 entry each for each service person with their customer total. Whatever I've tried to do in the detail or footer gives me errors.