multi column report problem

  • Thread starter Thread starter Richardson
  • Start date Start date
R

Richardson

I have encountered a problem that I haven't been able to solve, so I hope
someone has a suggestion.
I have a report with 2 columns, column A is on the left and column B is on
the right.
My data is a list of individuals and they are ordered based on grades with
the lowest grade in position 1,etc. I need to report to show these
individuals so that the first individual is in column B row 1, individual 2
is in column A row 1. This should repeat down as many rows as are
necessary.
EX:

2 1
4 3
6 5


I am open to any thought you have that would make this possible.

Thanks in advance,
Lori
 
Are your values actually 1, 2, 3, 4, 5, 6? If not, what is sort-defining
field name and what are typical values?
 
Currently the field to sort on is FinalFinish with integer values from
1-1200. If that makes it too difficult, I can make the values actually
1,2,3, by assigning rank before the values get to the report.

Lori
 
Set the sorting and grouping levels to
=Int(([FinalFinish]-1)/2) Ascending
[FinalFinish] Descending
 
Back
Top