How do I do sub totals in a query?
Have designed a personnel database for my customer who is the prime contractor and the main table lists all personnel by name and company. My customer wants the report this query drives to list each person by name and company (there are seven sub contractor companies). Additionally the customers wants the report to show the number of employees from each company. Report wopuld look something like this:
Name Company Total
Joe NG 5
Sam NG
Ed NG
Pete NG
Paul NG
George Raytheon 2
Bill Raytheon
Sally Oracle 3
Mary Oracle
Mike Oracle
Question is how do I get the query to return these sub totals?
Thanks