6 Replies Latest reply on Nov 18, 2016 7:25 AM by David Moyer

    Changing sort order in multi-column layout for flashcards

    otto_m

      Hi everybody,

       

      I have a simple vocabulary database with these fields:

      Field1 (Text) = word in Arabic script

      Field2 (Text) = word in Roman script

      Field3 (Text) = German translation

       

      To produce flashcards, I print them on labels with 4 fields across and 8 fields down in the order:

      A – B – C – D

      E – F – G – H

      I – J – K – L

      etc.

       

      This works fine for the front, but I have not yet figured out a method to print the back in reverse order:

      D – C – B – A

      H – G – F – E

      L – K – J – I

      etc.

       

      In Field4 (Calculation),

      “Let ( R = Get ( RecordNumber ) ; Ceiling ( R / 2 ) + ( Mod ( R ; 2 ) ) /10 )”

      to sort the fields in a new layout to print the back in reverse order.

       

      The calculation sorts fine in two-column layouts (B – A ; D – C etc.), but I am not able to modify the calculation so that it sorts across four columns (D – C – B – A ;  H – G – F – E etc.)

       

      Would you please help me out?

       

      Many thanks in advance,

       

      Otto