Columns report

[jean]

Hi I have already send a question regarding that issue but no satisfy
answer yet.


I have a table with 1 numeric field containing 300 records.

One page hold around 55 records (depending on the font), I am trying
to print everything on 1 Page.
I went in the page set up and I set a 6 columns report. The width of
each column is 1 inch

The report now have 6 column . The first 5 columns hold 55 records
each so it is 275. The last column contains 25 records. That what I
want and it is fine

The problem is that I want the total at the end of the last column.
Right now the total is alone on page 2.

Is there a way that the total appear at the end of the last column ?

thanks and hope this is clear enough now

 

[John Spencer]

You can do it if you switch Column layout from down then across to across then
Down.

However, here is a trick that you might be able to use if you want to use down
then across.

Open the sorting and grouping dialog. (View: Sorting and grouping)
Insert a NEW group at the very top level
Set the field/Expression to = 1
Set GROUP Footer to Yes
Close and save

In the group footer add a control that calculates the total. I assume that you
already have this in the Report's footer, so you should be able to move that
control from the report's footer section into the new group footer.

With Column Layout (on Page Setup: Columns) set to Down then Across, you
should see the total print at the bottom of the sixth column. If you have two
pages of data and only two columns on the second page the total should print
at the bottom of the last column that prints.


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County