My question is this:
I have a VBA script that (among other things) reads information from a table and stores it in an array (the size of the table). What I would like to know is this: Is it possible to sort it (using an SQL statement) by more than one column in the table? Let's say my statement looks like this...
strSQL = "SELECT * FROM testdb_main ORDER BY Name, Date"
Set rstTest = dbsTest.OpenRecordset(strSQL)
If I do this, it will only order it by name, and the dates are all over the place.
If anyone could help me, I would truly appreciate it. Thank you.