I have a select query within which I want to add a calculated query (Expr1 below), that uses another calculated query (Kgm below) in it's expression. I have set the format of Kgm in the query to fixed and limited it to two decimal places.
View attachment 108444
The problem I'm having is that Access isn't recognising the reference to Kgm. I get the little form seeking a value for Kgm. I'm not sure what I'm doing wrong. I used the expression builder to build the expressions, so the references should be correct (one would hope). The other calculated fields shown above are working.
I can work around this problem by repeating the maths , but I'd like to understand what I'm doing wrong.
Mike
View attachment 108444
The problem I'm having is that Access isn't recognising the reference to Kgm. I get the little form seeking a value for Kgm. I'm not sure what I'm doing wrong. I used the expression builder to build the expressions, so the references should be correct (one would hope). The other calculated fields shown above are working.
I can work around this problem by repeating the maths , but I'd like to understand what I'm doing wrong.
Mike