Query results into an array / string

C

Cowji

Hi Masters of Access Programming,

I am trying to produce an array or a string from a query. I can do this when
producing array/string from a row, BUT i want to produce array/string using
information in one column.

Thanks in advance
Cowji
 
V

Van T. Dinh

You can use VBA to create a Recordset based on the Query and then traverse
the Recordset to populate your array or concatenate values (from a specific
"column" as you need) into a String.

Check Access VB Help on Recordset, MoveFirst, MoveNext and EOF.
 
S

Sandra Daigle

Please see my reply in microsoft.public.access.modulesdaovba.

Rather than posting the same message to more than one group (multiposting)
please cross-post (send the one message to all groups at once). To
Crosspost, put all of the newsgroups into the Newsgroups field in the
message header. In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times.

See http://www.mvps.org/access/netiquette.htm for more information on the
best practices for using these newsgroups.

Thanks,
 
Top