[AccessD] Array sorting

Hi Listers,

I have a single dimension array of excel cell references stored as
string values.  I was wondering how you can sort a range that is say
A1:C3 from A1, A2, A3, B1... C3 to A1, B1, C1, A2, B2...C3?  Any help
would be greatly appreciated.


> regards
> 
> David
> 
> ----------------------------------------------------
> David Powell
> Computing Support Officer
> Worsley Alumina Pty Ltd
> Bauxite Mine
> Boddington WA 6390
> Ph: +61 8 9734 8269
> FAX: +61 8 9734 8250
> Mailto:david.powell at bbm.wapl.com.au
> WAPL Web Page http://www.wapl.com.au
> ----------------------------------------------------
 <<Powell, David (BBM).vcf>> 


NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege 
intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering 
the message to the intended recipient, be advised that you have received this message in error and that any dissemination, 
copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein.  
If you have received this message in error please notify the sender immediately and delete the message
Worsley Alumina Pty Ltd ABN 58 008 905 155 is the manager of the Worsley Joint Venture - Bauxite/Alumina Operation.
Liability and responsibility of the Joint Venturers is several in accordance with the following schedule of participating interests:
Billiton Aluminium (RAA) Pty Ltd 56 percent, Billiton Aluminium (Worsley) Pty Ltd 30 percent, 
Kobe Alumina Associates (Australia) Pty Limited 10 percent, Nissho Iwai Alumina Pty Limited 4 percent.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030807/a8742edf/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Powell, David (BBM).vcf
Type: text/x-vcard
Size: 464 bytes
Desc: Powell, David (BBM).vcf
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030807/a8742edf/attachment.vcf>