Calculations on a report

[cath240]

Im trying to calculate the sum of the total ive got this

total = [stockprice] *[QuantityOrdered]

=sum([stockprice] *[QuantityOrdered])

this works however when there are two records being shown it just gives the total sum of both records only want it to give one for each record

really need to get this

 

[Jack Cowley]

Use = [stockprice] *[QuantityOrdered] as the Control Source of an unbound field in the Detail section of the report. Use =sum([stockprice] *[QuantityOrdered]) as the Control Source for an unbound control in the reports Footer.

hth,
Jack