Problem of dispaly format in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have planning a report display format. Actually, i would like my report to
display a data format like:-

1 6 11
2 7 12
3 8 13
4 9 14
5 10 15

3 Column in one page. it is using to save a print out papers. but access
only have 3 display mode to me. Now a disply format is

1
2
3
4
5
6
7

It think it is too waste the space. Would you teach me how to do what i
discided? Do i need to code it or just use a design tool to change the
display format. Thank you very much
 
I have planning a report display format. Actually, i would like my
report to display a data format like:-

1 6 11
2 7 12
3 8 13
4 9 14
5 10 15
Click to expand...

Design the report so that it is narrow enough to fit on the page three
times; then go to Page Setup and pick the Columns page and ask for 3
columns, and order them Down-Then-Across.

This should do what you want. If you need anything much more complex, you
would be better off asking in the reports group.

B Wishes


Tim F
 
I have fellow your step to change the page setting to 3 columns in a page.
but i use preview view the page still have one column. Do i miss some step or
i have to change more setting? Thank you
 
I have fellow your step to change the page setting to 3 columns in a
page. but i use preview view the page still have one column. Do i miss
some step or i have to change more setting? Thank you
Click to expand...

Works for me. Things to check:=
1. make sure that the report width in the design window is small enough
to fit three times between the margins (e.g. 8.27 inch paper, 0.5 inch
margins, report must be smaller than 7.27/3 = 2.3 inch)

2. There must be enough rows to reach the bottom of the page and wrap
back up again..!

3. You can control (2) by using the sorting and grouping, and asking for
a page or column break before or after a group.

Hope that helps


Tim F
 
Back
Top