Sort some by ascending and some by descending

[chris9]

I have the following code that sorts the table in ascending order by MakeName, ModelName, and VIN

rst.Open "Select * From " & tnm & " Order By MakeName, ModelName, VIN", CurrentProject.Connection, adOpenStatic, adCmdText
'tnm is my table name

I want to now add two more fields EffYear and EffMonth and have those then sorted in descending order.

How do I sort in both ascending and descending order?

 

[VicM]

chris:

Write the SQL like this:

rst.Open "Select * From " & tnm & " Order By MakeName, ModelName, VIN, EffYear DESC, EffMonth DESC", CurrentProject.Connection, adOpenStatic, adCmdText


That should do it.

HTH,

Vic

 

[chris9]

Thanks you. I tried it with the () and [] but never tired it without them.