Sorting a table in Access Using VBA

[russeldraper]

Hello,

If I have a table called 'Mort' and a column in that table called 'Age', I was wondering if there was a way I could sort the table Mort (in ascending order, ie 0..100) in VBA by the column Age. And what the code for that sort would be.

Thanks for the help

 

[wemeier]

What are you trying to sort the table for? Do you want to view the table in a sorted order? Print the table in a sorted order?

If you want to view the table in a sorted order, you could build a query based on the table that includes the sort criteria, then open the query (or open a form based on the query).

If you are trying to print a report that is sorted, simply add the OrderBy clause to the report.


Cruising the Information Superhighway
[sub] (your mileage may vary)[/sub]