MySqli Vertical Repeating Region
I have a list of over 100 names which I would like to put in 4 alphabetically ordered columns using the last name.
It is pretty easy to make a horizontal repeating region with the MySqli SBs.
A B C D
E F G H
However, is it possible to do this vertically?
A E I
B F J
C G K
D H L
It does not seem natural to view these names listed in horizontal rows especially if one includes the first and middle names as well..
An alternative work around would be to have 4 (or more) Recordsets and separate corresponding repeating regions but some additional code
would have to be inserted into each Recordset showing only records 1-25, 26-50. 51-75, 76-100, etc.
I am not sure how to do this either.
Thanks for any advice.