groups detail section totals access 2003

[marfi95]

Hi all,

I know this can be done, but haven't figured out how yet. I have what
basically is a summary report that my sql comes up with for the detail
rows. I want to total these rows in the report and display
immediately below the detail section. I don't really want to group
anything, but want to treat the whole detail section as a group.

That being said, how can I get a "group footer" on the designer so I
can add my total columns. If I use "sorting and grouping", it starts
grouping things and that is not what I want.

I don't want to use the "page footer" because that would be at the
bottom of the page. this needs to follow the detail section. So
bottom line is I need a group footer, but only by using the entire
detail section as a group.

This report will never go across a page, so that is not an issue.

Any help would be appreciated.

Thanks !
Mark

 

[Allen Browne]

Could you place the text box to show the total in the Report Footer section?

 

[marfi95]

Could you place the text box to show the total in the Report Footer section?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.












- Show quoted text -

I will try that. I just figured, based on the designer, it would be
after the page footer, but thinking about that, that wouldn't really
make any sense.

Thanks for the help !

 

[marfi95]

I will try that. I just figured, based on the designer, it would be
after the page footer, but thinking about that, that wouldn't really
make any sense.

Thanks for the help !- Hide quoted text -

- Show quoted text -

That worked. Thanks again !