Error: you tried to execute a query that does not include...

[Gdm]

I am getting the following error on this query:



Error: you tried to execute a query that does not include the specified expression '...' as part of an aggregate function.

Here is the query:

SELECT DISTINCTROW
TeacherID,
TeacherName,
FeesRequired,
SubTotal
FROM MyQuery
GROUP BY
TeacherID,
TeacherName,
FeesRequired,
SubTotal
HAVING (SubTotal < FeesRequired)

I also tried WHERE, but get other errors.
Help is most appreciated.

[boblarson]

How about this instead:

SELECT DISTINCTROW MyQuery.TeacherID, MyQuery.TeacherName, MyQuery.FeesRequired, MyQuery.SubTotal
FROM MyQuery
WHERE (((MyQuery.SubTotal)<[FeesRequired]))
GROUP BY MyQuery.TeacherID, MyQuery.TeacherName, MyQuery.FeesRequired, MyQuery.SubTotal;

[Gdm]

Thanks, boblarson, you got it first time!
With some minor tweaks, I have exactly the results I wanted.