using sections correctly

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hello,

Im relatively new to Access and have a couple of questions
in regards to headers and footers. How can I create a new
section or title a new section? IE IF I wanted to create
multiple headers/footers for different sections how would
i do that?

Also, in relation to that question I am trying to sum data
in my report but am coming up with a #error. The formula
I am using is simply =Sum([what Im summing]). I am in the
page footer section, should I be somewhere else?

Thanks for your help!
 
Hello,

Im relatively new to Access and have a couple of questions
in regards to headers and footers. How can I create a new
section or title a new section? IE IF I wanted to create
multiple headers/footers for different sections how would
i do that?

Also, in relation to that question I am trying to sum data
in my report but am coming up with a #error. The formula
I am using is simply =Sum([what Im summing]). I am in the
page footer section, should I be somewhere else?

Thanks for your help!
Click to expand...

1) You can Group data in the Sorting and Grouping dialog.
View + Sorting and Grouping
if that is what you mean.

2) See Microsoft KnowledgeBase article:
132017 'How to sum a column of numbers in a report by page'
 
2 things: to add new group headers or footers, click on
properties box of the report in the far left corner. Go
to sorting and grouping. If you want a group header or
footer put yes in the box.

If some of your fields that you are trying to sum on
are "null" access has a problem summing them. But, there
is a lengthy way around it.
 
Back
Top