order by

[GoodLife22]

Set rs = db.OpenRecordset("select * from qry_List_Status where  CONTRACTORS=""" & rsclient!client & """", dbOpenDynaset)

This is a small snip-it for a VB code which saves data from a query to an excel sheet then email it to a client. It works pretty well except the excel sheet needs to list the last names alphabetically. The query "qry_List_Status" is sorted alpha by [LastName] currently, but by time it gets to Excel IF my list client has more than 356 records the alpha order does not keep things correct.

So how would I add a ASCENDING ORDER by [LastName] to this line of code?

 

[Kryst51]

Check this out and see if it helps