I'm looking for a simple line or two of code to sort an Access able by a specific field. Thus far I have tried the following and some variations of it but without success. I want to sort the field WtdAvgPctGoalMet in descending order.
Dim strSQL As String
strSQL = "ALTER TABLE [table name] SORT COLUMN WtdAvgPctGoalMet Desc"
The above produces a syntax error message but gives no clue as to what should be changed. Any suggestions would be appreciated.