Keeps asking me to fill manually values for a column

[FLabrecque]

I have a somewhat complex query. I calculate the value of field [MFCFCST_CS]. If I run it like this, no problem. I have the good values. In the next column, I use it in another complex calculation. When I try to run the query, I have a pop-up, asking me the value of [MFCFCST_CS].

I'm quite sure this is a routine mistake, but what am I doing wrong?

 

[FLabrecque]

Trying to debug this, I can see that it is only when I enter a criteria that the pop-up show up. Without it, it runs fine. Any clues?

 

[Mile-O]

You can't use the result of a calculation in the same query. You can either:

1. Base a second query on a first query in order to use the calculation;
2. Substitute the result field in your query for the complete calculation again.