Sustotals in report Access 2010

[joylove89]

Hi

I am trying to add sub totals at the end of each order Total but unable to do so despite typing in sum([ExtendedPrice])
Any suggestions?



Thanks
Shirl

[June7]

Where did you enter that expression? In a group footer textbox? Is ExtendedPrice a field in the report RecordSource? Aggregate functions can only be used with field, not textbox.

[joylove89]

I figured it now - I did not group on group number, and then on group footer but now it worked - I broke my head over this. Thanks heaps though - problem solved.