subqueries in an expression

[Rasberry]

I am getting the following message regarding my subquery:

Subqueries cannot be used in the expresion (Sum(/<.2)).

This is my query:

MinimumLimits: IIf(Sum([Percent]<.2),"False","True").

Note, my Percent field works.

 

[Norie]

Shouldn't it be.

Sum([Percent])<.2

Or are you actually trying to sum Percent if it's less than .2?

 

[Rasberry]

Thanks for the quick response. I am not trying to Sum the percent if it is below 2%, but I tried your version, and I still get the same response that I cannot use subqueries in this particular expression.

 

[Norie]

What do you want to sum?

 

[Rasberry]

I guess I wasn't trying to sum anything and when I removed the word "Sum", it worked. Thank you!!!!