I need some help with some code to read fields in a column and combine them into one string.
For example, I peform a query, then want all the results in the column to be output as one string.
Using a recordset will solve your problem.
Dim rs as Recordset
Dim strSQL as String
Dim counter as Integer
strSQL = "SELECT ..........FROM.........WHERE..........ORDER BY........."
rs.Open strSQL, CurrentProject.Connection, adOpenForwardOnly, adLockReadOnly
Do While Not rs.EOF
For counter = 0 to rs.Fields.Count -1
If everything went OK the debug.print should show you all the fields of one record.
The moveNext-statement goes to the next record of the recordset.
Using the Fields-property gives you the possibility to concatenate in a string.