Expression referencing same query

[jj44]

Hello,
I am trying to write a simple query that references calculations in the same query - but I keep getting the "enter parameter value" box.

Basically, I have some columns in a query calculating average and sum values for a column. I would then like to multiply some of those columns together in a new column, using an expression like this: =[AvgOfColumn1]*[SumOfColumn2]. Access doesn't want to do this for me. It seems very simple so I'm sure I'm missing something!

Thanks!

 

[KenHigg]

You could simply make this 2 queries.

 

[Ziggy1]

asecond query based on the first will work,

you can also make sure the totals row says "Expression" in your calculated field, and try redoing the expression with the "Exp builder"...click Save

I know what you are going through it happens all the time, I just did a quick test and it happened, then did what I described above and it worked....go figure

 

[jj44]

Thanks guys - it was changing the "Totals" column that I was missing!