How do I sort in Visual Basic?

joopdog
01-14-2004, 08:53 AM
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.

nelly25
01-14-2004, 09:02 AM
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.

MKoslof
01-14-2004, 09:08 AM
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.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum