Sorting arrays

[JC10001]

Hi guys,

I have an array that I would like to sort in descending order. I've tried looking in my book and on google but I can't seem to find any information about functions that would do this. How does one sort an array in access?

 

[dcx693]

I recalled seeing this topic discussed in Access Cookbook (by Ken Getz, Paul Litwin, and Andy Baron). Apparently, there is no built-in mechanism for sorting an array in Access. You need to program your own sort mechanism or save the data to a table and sort it there. The book gives an example using the quicksort algorithm.