Sorting Access Tables

[zggs90]

Can anyone help me write a bit of VB code to sort an Access Table by a specific field?

I can sort the data when I read it but would like the table to remain sorted.

Thanks

Geoff

 

[chadt]

its not VB code......but a SQL statement......maybe you can tell us if your using Access, SQL Server....etc. There are so many ways to sort data by a field

'''''''''''''''''''''''''''''''''''''''''
Dim sSQL as String

'Ascending
sSQL = "SELECT * FROM YOUR_TABLE ORDER BY YOUR_FIELD"

'Descending
sSQL = "SELECT * FROM YOUR_TABLE ORDER BY YOUR_FIELD DESC"
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Good Luck