Columns ruling Group footers.

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

I'm using access 97.

I'm trying to create a report that can divide my
information correctly.
I'm using sorting and grouping to keep my information in a
particular order.
I have my Page setup as 3 columns (here's where my problem
originates, I'm sure).

The problem I'm running into is the Group Footer, I only
want the footer to show up at the end of each group.
However, the footer is meant to be the width of the page,
NOT the width of the columns in the page setup.
It shows up as if it were part of the page setup.

I'm hoping that there is some sort of code I may utilize
that can control either the columns (instead of page
setup), or the footer (to ignore page setup).

I'm not the best at using the code builder, and if the
suggestion has anything to do with that, could you please
give full "dummy" instructions on how to do it?

People have recommended "On Format" code to me before, and
all it has done is create errors Maybe I'm doing it in the
wrong place. I'm afraid I am either doing something wrong,
or worse (something is wrong with my Access).

Any help will be greatly appreciated, and thank you in
advance.
 
You might take out your details and place them in a separate, three column
subreport. Then add this subreport on your main report and set the Link
Master Child properties to your previous Grouping field. Your main report
would not contain the details and there would be no need to set the Grouping
to your previous field since the value should be unique.
 
The order of the details heavily relies on the rest of the
report, is there a more simple way?
 
I tried that and whatever the master report is set to, it
rules the sub report. If the sub report is set to three
columns and the master to 1, then the master dominates the
sub and vice versa. Is this normal?
 
Your main report will be sorted by your previous group field. The subreport
can contain columns. Make sure the columns in the subreport are set to
display across then down.
 
Back
Top