query expression in an expression

[mbardwel]

I am building a query in Access 2003. Here is my problem.

I create an expression called SUN_ST
In a later expression I reference a calculation based on SUN_ST
ie, MON_ST=sum-SUN_ST

SUN_ST is not a value in a table it is a calculation/expression within the query.

How do I reference a query expression within an expression.

I tried MON_ST: [sum]-[SUM_ST] and when I run the query I get asked to enter the parameter value for SUN_ST

Any help would be appreciated.

Thanks

[ADezii]

I am building a query in Access 2003. Here is my problem.

I create an expression called SUN_ST
In a later expression I reference a calculation based on SUN_ST
ie, MON_ST=sum-SUN_ST

SUN_ST is not a value in a table it is a calculation/expression within the query.

How do I reference a query expression within an expression.

I tried MON_ST: [sum]-[SUM_ST] and when I run the query I get asked to enter the parameter value for SUN_ST

Any help would be appreciated.

Thanks

You would have to reference the entire Expression that SUN_ST refers to.

[mbardwel]

You would have to reference the entire Expression that SUN_ST refers to.

That is what I thought... if anyone has any other ideas that would be great.

[NeoPa]

There are rules about this. In some circumstances this is allowed, but in others it's not. It depends on the order of processing.

Post your current SQL (if it's not too vast) and we'll see what we can find.

Alternatively, a fairly foolproof method is to use a subquery to produce the calculated value (See Subqueries in SQL).