Sorting an Array

[solo7]

I have an array Var(6). In which the values held are from 1 to 10. Can anyone suggest a way of sorting these values into ascending order?
so Var(0)=lowest value
etc, etc,
Var(6)=highest value

I have managed it with a very code intensive 'And''Or''=' combiation, but there must be a more efficient way.

Steady ...
%-)

 

[gusbrunston]

Dear Solo:
There is a discussion in thread181-55225 in Microsoft Access General Discussion which may be helpful to you. Gus Brunston
An old PICKer
padregus@home.com

 

[solo7]

Cheers !!