DCount or DISTINCT in Crosstab query

[kvar]

I have a crosstab query, among other things, it counts the field Policy Number to tell me how many policies were sold. Those are a unique value anyway so that count is accurate. I'm also trying to get it to tell me the number of agents that sold those policies. I need it to count the Agent # but only to count unique values. Obviously 1 agent could have sold many more than one policy.
Here is what I have so far, all of my attempts to add a DCount or DISTINCT have just resulted in errors so any help or direction is much appreciated!!

TRANSFORM Sum([__Face Amount]/[SumOf__Face Amount]) AS PercentOfSales
SELECT EA_PrimaryAgent_tbl.[DISTRICT #], Count(EA_ActiveLife_West.[__Policy Nbr]) AS [CountOf__Policy Nbr], Count(EA_ActiveLife_West.[AGENT #]) AS [Agents Selling]
FROM EA_ActiveLife_WEST_TotalYTDSales_qry RIGHT JOIN ((EA_ActiveLife_West LEFT JOIN LifeProductList_tbl ON EA_ActiveLife_West.[__Product Long Name] = LifeProductList_tbl.[Product Long Name]) LEFT JOIN EA_PrimaryAgent_tbl ON EA_ActiveLife_West.PrimaryAgentNumber = EA_PrimaryAgent_tbl.[AGENT #]) ON EA_ActiveLife_WEST_TotalYTDSales_qry.[DISTRICT #] = EA_PrimaryAgent_tbl.[DISTRICT #]
WHERE (((Year([__Issue Date]))=Year(Date())))
GROUP BY EA_PrimaryAgent_tbl.[DISTRICT #]
PIVOT LifeProductList_tbl.[Term/Perm];

 

[namliam]

What you want to do isnt possible in one statement in Access unfortunately.
You will have to stack queries something like
Query1: Select distinct Agent#
Query2: Select count(agent#)

Also please review: http://www.access-programmers.co.uk/forums/showthread.php?t=225837&highlight=naming+convention

 

[kvar]

Oh if I only I could name the fields. Lol. Would save me a lot of headaches.
I was afraid that was going to be the answer, was really hoping I was wrong. Oh well, worth a shot. Thank you!