Summary Options

[k f h]

Hi All,

I'm in the design view of a reoprt and forgot to add a tick in the Summary
Options box. Is it possible to add this tick without re doing the whole
Report.

Thanks,

kfh.

 

[Damien McBain]

Hi All,

I'm in the design view of a reoprt and forgot to add a tick in the
Summary Options box. Is it possible to add this tick without re doing
the whole Report.

Yep, in design view, right click one of the headers (page or report) and
choose "sorting and grouping". Add the field/s you want to group by (in
other words summarise) and give it a group header or footer (depending on
where you want the summarised data to appear. You can then add calculated
text boxes to the group header or footer (with the control source as
=Sum([FieldYouWantToToSum)] etc)

hth

Damo

 

[k f h]

Hi Damo,

Thanks for that tip I need to display sub total for value. using the above
method how and where would I type this.

Thx

kfh.

Hi All,

I'm in the design view of a reoprt and forgot to add a tick in the
Summary Options box. Is it possible to add this tick without re doing
the whole Report.

Yep, in design view, right click one of the headers (page or report) and
choose "sorting and grouping". Add the field/s you want to group by (in
other words summarise) and give it a group header or footer (depending on
where you want the summarised data to appear. You can then add calculated
text boxes to the group header or footer (with the control source as
=Sum([FieldYouWantToToSum)] etc)

hth

Damo