Create a text string from multiple records in the same field.

[Michael]

I have generated a select query that returns one field, the inventory number
of items sold between 2 dates. This obviously creates multiple "records"
that I could use to create a report and output a list. What I need to do is
take these results and output them in 1 text string. For example: If the
results are "A1" and "B1" and "C1" and "D1". I need to be able to create a
text string that reads "A1, B1, C1, D1"

Is there a way to do this?

 

[Duane Hookom]

There is a generic function and sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Van T. Dinh]

You can use VBA code to open a Recordset based on the Query, traverse
through the Recordset and concatenate the value from each iteration.

See The Access Web article:

http://www.mvps.org/access/modules/mdl0008.htm

for sample code doing similar comcatenation from a Table.

 

[Michael]

Thank you to both of you that replied. That was just what I needed.

--
Thanks,
Michael W

There is a generic function and sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.