error when trying to do a calculation in query

[slimjen]

All; I don't do a lot of calculations in my queries but this one calls for it. But I'm getting an error: your query does not include the specified expression. In my query I want to perform a calcuation:

Taxes: ([AvgEE]+([AvgEE]*(1+[TO])/2*[base]))

I get the above error but when I put a SUM or AVg in front of it:

TaxableWgs: Avg([AvgEE]+([AvgEE]*(1+[TurnoverRate])/2*[wage_base]))

This works but with the wrong results from my manual calculation. Even if I break it down I still get the error. What am I doing wrong?

[JoeM]

Are you doing this in an Aggregate (Totals) Query?
You need to do an Aggregate Query if you want to do an Average or Sum, as you need to tell the query which fields you are grouping by.

See:
http://www.fontstuff.com/access/acctut04.htm
https://www.techonthenet.com/access/...umeric/avg.php

[CJ_London]

not sure if relevant, but your first example uses TO, the second TurnoverRate

[ssanfu]

your query does not include the specified expression.

This usually means that the referenced fields are either
a) misspelled or
b) not in the query.

Does the query have fields (columns): "AvgEE", "TO", "base" (or "TurnoverRate", "wage_base")??

Maybe post the SQL of the query??