URGENT: Sequence Prob...... Please help.

  • Thread starter Thread starter KRISH
  • Start date Start date
K

KRISH

Hi!
Anybody help me how get a report for seating order of
applicants of an exam. The seating order should be like

1 2 3 4 5 6 7 8 9 10
20 19 18 17 16 15 14 13 12 11
21 22 23 24 25 26 27 28 29 30 ...... so on

say the above given no. are application no.

kindly note that the flow order is

----> -----> ------>
<---- <----- <------
----> -----> ------>

Please let me know is there any way to design the report
as above.

Thanks for any help
krish
 
Krish, the only way I see to do that type of arrangement is to create a new
field in the table and manuall assign a sequence number, than order the
report on that sequence number but print your student number.
Hope this helps.
Fons
 
I have a table of numbers with a numeric field (Num) with values 1-100. I
created a 10 column report that displays across then down. I set the sorting
and grouping.

First Level of sorting:
=(([Num]-1)\10)*1000+(((([Num]-1)\10) Mod 2))*(10-([Num]-1) Mod 10)

Second Level of sorting:
[Num]

There might be a less complex expression but this seemed to work as long as
your numbers are consecutive like your example.
 
thanks a lot Mr. Duane Hookom
krish
-----Original Message-----
I have a table of numbers with a numeric field (Num) with values 1-100. I
created a 10 column report that displays across then down. I set the sorting
and grouping.

First Level of sorting:
=(([Num]-1)\10)*1000+(((([Num]-1)\10) Mod 2))*(10-([Num]- 1) Mod 10)

Second Level of sorting:
[Num]

There might be a less complex expression but this seemed to work as long as
your numbers are consecutive like your example.
--
Duane Hookom
MS Access MVP
--

Hi!
Anybody help me how get a report for seating order of
applicants of an exam. The seating order should be like

1 2 3 4 5 6 7 8 9 10
20 19 18 17 16 15 14 13 12 11
21 22 23 24 25 26 27 28 29 30 ...... so on

say the above given no. are application no.

kindly note that the flow order is

----> -----> ------>
<---- <----- <------
----> -----> ------>

Please let me know is there any way to design the report
as above.

Thanks for any help
krish
Click to expand...


.
Click to expand...
 
Back
Top