Retrieving values from a query and putting it into a collection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a problem regarding retrieving a number of results from a query
(which is fine and working) and putting them in a collection within the code.
The problem I seem to be having is executing the query from the code and
putting it into a collection.

Any tips/advice much appreciated.

Thanks,
Jen
 
Jen said:
I have a problem regarding retrieving a number of results from a query
(which is fine and working) and putting them in a collection within the code.
The problem I seem to be having is executing the query from the code and
putting it into a collection.
Click to expand...


Seems pretty straight forward, just open a recordset on the
query and loop through the records appending the value to
the collection. But WHY?? A recordset is often easier to
work with than a collection.
 
Back
Top