Aggregate functions on calculated fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have in my detail section of my report a calculated field, something like [quantity]*5-quantity begin a field in a query. The name of the textbox is txtPrice and what I would like to do is get the sum of this textbox in the footer section of the report, but when is use somehting like sum([txtPrice]) it thinks its a user input.
 
The simplest solution is probably to move the calculated field into the
query the report is based on. In query design view, a fresh column of the
Field row, enter your expression:
Price: [quantity]*5-quantity
You can now sum the Price field in the report.

Alternativley, repeat the expression in the box where you want to get the
sum:
=Sum([quantity]*5-quantity)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Gabriël123 said:
I have in my detail section of my report a calculated field, something
Click to expand...
like [quantity]*5-quantity begin a field in a query. The name of the
textbox is txtPrice and what I would like to do is get the sum of this
textbox in the footer section of the report, but when is use somehting like
sum([txtPrice]) it thinks its a user input.
 
Back
Top