Aggregate Function query

[Lee]

I am having problems with a query (one that worked
properly yesterday). It is telling me "You tried to
execute a query that does not include the specified
expression as part of an aggregate query." As I said, I
don't understand because it worked yesterday. Basically, I
need to do this as a parameter query.

SELECT qry2004.Gender, qry2004.[2004 Med Option], qry2004.
[2004 Med Coverage Tier], Count(qry2004.[2004 Med Coverage
Tier]) AS [CountOf2004 Med Coverage Tier], Avg(qry2004.
[Annual Salary]) AS [AvgOfAnnual Salary]
FROM qry2004
GROUP BY qry2004.Gender, qry2004.[2004 Med Option],
qry2004.[2004 Med Coverage Tier]
HAVING (((qry2004.[2004 Med Option])="EPO"))
ORDER BY qry2004.Gender DESC;

Any help would be greatly appreciated.

 

[Duane Hookom]

Try
SELECT qry2004.Gender, qry2004.[2004 Med Option], qry2004.
[2004 Med Coverage Tier], Count(qry2004.[2004 Med Coverage
Tier]) AS [CountOf2004 Med Coverage Tier], Avg(qry2004.
[Annual Salary]) AS [AvgOfAnnual Salary]
FROM qry2004
WHERE [2004 Med Option]="EPO"
GROUP BY qry2004.Gender, qry2004.[2004 Med Option],
qry2004.[2004 Med Coverage Tier]
ORDER BY qry2004.Gender DESC;