Save query result into an array

[rwahdan1978]

Hi

I have this query:

Set rs2 = CurrentDb.OpenRecordset("SELECT userID from users where score = " & thescore)
    
    While Not rs2.EOF
    
        MsgBox (rs2!UserID)
        rs2.MoveNext
    
    Wend

instead of having to show the values in message box, I would like to get the results saved into an array. How to do that?

[Welshgasman]

Get the record count by moving last and use that to dim an array
Then movefirst and populate that array, incrementing a counter.

[Micron]

Or loop over the recordset and concatenate along with a delimiter (e.g. comma) and use Split() on that string?

[moke123]

In addition to the methods already mentioned you could also use a collection, or my personal favorite, a dictionary.

What do you want to do with your data once you have it in an array?