inserting a query into an aray?

[carnevil00]

Hi i am having a problem that will probably be very simple for you guys

I want to generate a query then insert all the values into an array
I know it is simple when u select only 1 value from the entire query and put it in a single variable, but if the query returns a large list of values I need a way to store them into a variable..

how would i do this?

I am using VBA for access

thanks in advance

 

[Sergeant]

Look at the GetString method of the Recordset object in VBA help.

 

[RuralGuy]

Why do you need to use an array? Why won't the RecordSet work for you?

 

[pono1]

I'm sure Sergeant actually meant the GetRows method of the ADO recordset object.

Regards,
Tim

 

[Sergeant]

Yeah, one of those...GetString...GetRows.
Thanks Tim, for getting my back.

 

[pono1]

No problem. Sunday typos...I hate them...