Summing a count function for a report

[Barry Phillips]

I am working on a database for sales leads. I have two tables which hold
dfferent type leads (Dealers & Homeowners), I already have several queries
set for each to select leads for each territory by state and to count leads
for each of our sales territories. What I need to be able to do is add these
Count functions together to get total leads for each territor. See below

These are seperate queries
qry dealer lead terr 1: count(*)
qry home lead terr 1: Count(*)

I need to add the count totals to get a sum for the territory for a report.
Any direction would be a great help. Actually there are a total of 4 tables
which holds leads for each territory I will be quering from but I only
included these 2 to simplify.
I need to do this for 22 Sales Territories any direction of how to
accomplish would be a great help.

 

[Fons Ponsioen]

Hi Barry.
The way I would approach this is to create a totals query for each of your
tables grouped by territory. This would provide you with a total for various
territories.
Than using the territories table linking it to the various totals querries
with all from territories and only those matched from the totals querries
will give you a source for a report as you described.
Hope this helps (and is fairly clear).
Fons