Adding Products in Report

[Paul Cooke]

Hi Guys

For the life of me I can not work out why I can't get a report to add all the products on it.

On a test report I have 4 products with values of 50,60,60,80 but the Subtotal box only shows 50 when it should be 250.

Any help or advice would really be appricated !!

many thanks

 

[pbaldy]

What's the control source of the textbox? What section is it in?

 

[Paul Cooke]

Hi Paul - thanks for the quick reply

The control Source is 'Total' (as below)

Total: [VaccineProducts]![VaccineCost]

and its in the Report Footer

thanks again for any help you can offer

 

[Paul Cooke]

Hi Paul - just to let you know I have worked it out I only needed to sum the 'VaccineCost'

thanks anyway

 

[pbaldy]

Glad you got it sorted out.