In MS-Access you can create a Recordset using the OpenRecordset on a database.

Once you have that record set, you can get the rows with the GetRows() function.

It has one advantage: once the function returns the data remains consistent (it is in an array). The really bad part is... what is returned is an array. This means all the fields are now numbered instead of named.

So with the GetRows() you end up doing row(x, 0) where x is the column number (starting at 0) as found in your SELECT statement. You could instead use rcd("<column name>"). That way, if you change the order of the columns in your SELECT, your code continues to work.