Unexpected request for parameter

[stickers]

I have created a query with 3 calculated fields. The first is 'TotalQuantity' and is a sum, calculating a value using two fields from separate tables. The second two both refer to this field, multiplying it by other fields in the query.

When I run the query, I get a box asking me to enter a Parameter value for TotalQuantity. Why? I have looked at the tips on Access help and none of them work. I have tried building the expressions both by typing them in and by using the Expression builder, so it's not a spelling mistake.

Should I use fields from the underlying tables to multiply TotalQuantity by?

Can anyone help?

Thanks

 

[r937]

access does not let you use the column alias name in exzpressions

replace TotalQuantity in the subsequent expressions with the sum that defined it


rudy

 

[stickers]

Rudy,

Thanks for the help - I'm a bit of a newbie at this. Works perfectly now.

Stickers