I am running a group by query that most of the fields are summed, but the
last field I want it to count but not every record I only want it to count
the unique entries, basicly here is the total production and how many
dealer's the production came from.

SELECT [Credit Guard Report].Region, Sum([Credit Guard Report].Unemployment)
AS SumOfUnemployment, Sum([Credit Guard Report].Life) AS SumOfLife,
Sum([Credit Guard Report].[Unemp-Death]) AS [SumOfUnemp-Death], Sum([Credit
Guard Report].[# Covered]) AS [SumOf# Covered], Count([Credit Guard
Report].Dealer) AS CountOfDealer

FROM [Credit Guard Report]
GROUP BY [Credit Guard Report].Region;

Any suggestions would greatly help.