I would like my VB code to sort all data in my table in the following way: Sort column1 then column then column3. The VB code is below.
DoCmd.RunSQL "SELECT Table1.* FROM table1 ORDER BY table1.column1, table1.column2, table1.column3
I keep getting an error message A runsql action requires an argument consisting of an SQL statement.
Will someone help me make this code work?
Ideally here is what my table should look like