SQL and VB

[skooby]

I am wanting to allow the user to click Sort Ascending or Sort Descending and have a datagrid sort by name accordingly. How can this be done w/ SQL or is there an easier way to do this?

Thanks

[Bigley]

At the end of your SQL statement use the ORDER BY clause and select the field you wish to order by eg.

Select * from Customers
Order By LastName

You can also specify Asc/Desc dependiong on which you want, default is Asc.

[skooby]

Here is a sample of the code I am using.....Right now I have menu as follows....

Sort
Sort Asc
Sort Desc

But when I click these nothing happens

Here is the code in the Sort Desc routine

cDbase = "C:\PhoneDirectory.mdb"
cTable = "Directory"
cSort = " ORDER BY "
cField = ""
cSelect = "SELECT * FROM "
cTry = "SORT DESC"

Adodc1.RecordSource = cSelect + cTable + cSort + "Name"

DataGrid1.Refresh

Any suggestions?

Thanks