Query Question

[fredk]

I have a table that contains all of the main data the table contains group information to include a group name, account manager, effective date and number of contracts.-

The account managers are broken up into two seperate regions, north and south.

I want to create a query (for a report) that shows the totals for each group of account managers and then give a total of all data.

Do I have to create two seperate queries (one for each group of account managers)and then a third query to bring the two together? If so, how would I tie the data together?

The query will have the following fields:

Account Manager
Group Name (counting the number of groups)
Contracts (summing the number of contracts
Effective Month (grouping the data by effective month

Thanks for the assistance!!!!!!

Fred

 

[joshuar]

Do you need the combined totals information in the query? Why not just group based on region on the report and place an overall sum at the bottom?

 

[fredk]

Actually, I don't have a "region" set up in the table, (although I certainly could) In that case I would have to associate a region to each record. If that is the only way to do it, it works for me. I was just trying to avoid adding another filed to the table.

I guess I could just add an event that inserts the region based on the sales rep.

Is that the easiest way?

Thanks very much for your help joshuar

Fred