Access2010 SQL syntax to Average and Count result

[PeggyMcP]

I am trying to run this query, but the results are always just the count; the average part doesn't happen.

SELECT [Rater Type], AVG(RaterTypeCount) From
    (select [Rater Type], Count(*) as RaterTypeCount
      From RatersPerParticipants
      where LOB="Product Sale" and [Rater Type]="Boss"
      Group by [Rater Type] )
Group by [Rater Type]

Table
LOB Rater Type # of Raters

a Plain count of "Product Sale" "Boss" (below) returns the same value as above

SELECT Count([Rater Type]) as RaterCount
From RatersPerParticipants
where LOB="Product Sale" and [Rater Type]="Boss"

[June7]

Because the outer query is selecting and grouping on the [Rater Type] field. Maybe you want:

SELECT AVG(RaterTypeCount) As AvgCount From
(SELECT [Rater Type], Count(*) AS RaterTypeCount
FROM RatersPerParticipants
WHERE LOB="Product Sale" AND [Rater Type]="Boss"
GROUP BY [Rater Type]) AS Q1;

[PeggyMcP]

Thanks, June7! Minutes after stepping away from the puzzle I also realised that I was counting the wrong field. If I couund the number of raters like I should, then I think I can select the rater type to identify the averages and the avg will work. Just a bonehead blunder. Thanks for your gentle reply (I'm new to using forums).

[June7]

Count() isn't using a particular field, doesn't have to since what is counted is records. Did you mean you were grouping on the wrong field?