How to give an Expression a Criteria

[DaniBoy]

Hello Everyone,
I have a query where three og the flieds are expressions.

Expression #3 is made up from Expression #1 and #2, when I put a criteria on the Expression #3, I get a parameter to fill in Expression#1.

I know that if I make another query from this query it will work, but how do I make a criteria on the Expression #3 on the same query?


Thanks
DaniBoy

 

[Adrianna]

I think it's because of order of operations.

You queries is trying to find out all of the limitations so that it can define what records match the criteria.

You're trying to impose criteria on an aggregate expression which has not yet determined it's values.

I can't tell you how to fix it because I don't know exactly what you are trying to limit...or use it for.

You may need to run a macro or code that performs the first calculation and then runs a second query on the results of the first!