Is it possible to reference the result of an expression in the formula for another expression, all within the same query?
For example:
Expr1: [Table1]![Field1] * [Table2]![Field2]
Expr2: [Expr1] * [Table3]![Field3]
Is this possible, or do I have to create a subquery? I would like to avoid recalculating as much as possible...the expressions in my queries are much more complicated than this and they are being performed on large sets of data.
Thanks!
Evan