Calculating within a query using data from a COUNT function

[elliem19]

Hello again! The most annoying thing about my question is how to word it (and therefore how to search existing threads for similar problems).

I'm building a query and in a nutshell I have two columns and want to add a third which will multiply the other two together. Simple!

BUT... the value in one of the columns is the result of the COUNT function, so if I try to multiply the two together, it isn't taking 'Count' into the calculation and thus my result is incorrect.

Is there a simple way to create an expression that recognises the result of the COUNT in column 1 before multiplying by the second column?

I've tried Expr1: [CountOfProduct]*[Quantity] but this results in a parameter box popping up, asking me to manually enter the figure for CountofProduct

Thanks in advance

 

[Brianwarnock]

If I understand what you are saying you are trying to use a Count that is taking place in the query, this cannot be done as the count does not exist until the query has finished, you need to do the count in one query and use it in a second.

Brian