How do I sort in Visual Basic?

I'm a newbie. And I like to sort and then create a permanent sort in an Access database table.

The fields I have so far are the following:

TDATE
TSERIES
TNAME
TADDRESS
and so on...

I like to first sort by TSERIES, then by TDATE. Then eventually copy this into another table.

I'm a newbie. And I like to sort and then create a permanent sort in an Access database table.

The fields I have so far are the following:

TDATE
TSERIES
TNAME
TADDRESS
and so on...

I like to first sort by TSERIES, then by TDATE. Then eventually copy this into another table.

Easiest way is to create a query and call this from your VB application.

You could create a custom query based on your original table and then use that query to populate a new table.

Or the recordset object does contain a .sort property.