Columns in report

[Guest]

I am trying to arrange up to 640 records of one digit in a report divided in
tables of 8 rows and 5 columns.

These records are numbered in the report with a field that makes an overall
sum from 1 to 640.

I would need the report to show something like that:

1 A 16 A 17 A
2 A 15 A 18 A
3 A 14 A 19 A
4 B 13 A 20 B
5 B 12 A 21 C
6 B 11 B 22 C
7 B 10 B 23 B
8 B 9 B 24 B and so on.....40 A

The data are not a problem. It is the formatting! Any idea on how I can get
practically a number of tables of 8 rows by 5 columns in a report arranging
the 640 records the way I want them?

Thanks for any help

 

[Guest]

When creating a new report, use the AutoReport wizard and play with it. Took
me about 10 minutes to learn, having never used it before...

 

[Joshua A. Booker]

Start a new report using the Labels Wizard.
Specify Landscape
Specfiy a Custom 1 in. tall X 2 in. wide label
Choose your fields
and finish the report by using the Columns Tab of the Page Setup window.

HTH,
Josh

 

[Guest]

Thanks bopth to Josh and Dennis for their suggestions, but I am afraid it is
a lilttle more complicated than that. I will try however to use your
suggestions. Thanks.

 

[John Spencer]

The only way I can see to start on this is to calculate the section number,
the column number and the row number for each of your values (N). Then sort
your data by these calculated numbers

Section Number should be (1 to 8)
(N\40) + 1

Column Number should be (1 to 5)
(((N-1\8) +1) Mod 5) +1

Row Number is tricky since it switches direction (according to your posting)
(N Mod 8) + 1 for ascending values (1 to 8)
9 - ((N Mod 8) + 1) for descending values (16 to 9)

But you can use the Column number calculation slightly modified to determine
if you are in an odd or even row and multiply 9 by the result (0 or 1)

((((((N-1\8) +1) Mod 5) ) Mod 2) * 9) - ((N Mod 8) + 1)

Hopefully I've got all those numbers correct. And hopefully you will be
able to work out the report structure with this schema.

 

[Guest]

Thanks John, I think yours is a good suggestion and I will experiment and see
what I come out with. It is a tricky problem as you said. I will let you know
if I sort it out.

Thanks again.