Sort an array

[klasse]

Hello,

I have an array (1 to 150, 1 to 3) where the first column values will be dates and the second integers.

The array gets the values from a txt file.

I create a table and then fill the table with the values in the array. I need the values in asc order by date.

Any ideas?

Thank you!

Klasse

 

[MichaelRed]

Set the property of the date column.

Open the table in design view. Select View;Properties on the menu. Enter the field name of the date field in the order by property (~~ the 5th one down) MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[klasse]

Hi,

This table is created via DAO
Set tdfNew =currentDb.CreateTableDef("USAGE&quot

and is created exclusively for a graph; when the user opens the graph, the table is created, and when such graph is closed, the table is dropped.


So, I can't open it in design view.
Thanx for the tip anyway!

Klasse