Hi,
Can anyone help me?

I need to combine an undetermined number of text fields into one field in a query. In other words, if I have the following:

ID Name
1 Liz
2 Tertia
3 Peter
4 Paul
5 Sue

I would like to conbine the Name field into one:

Liz ; Tertia ; Peter : Paul ; Sue

There is no definate number of names, so I would need an expression that will combine all Names in the row with a ; in between.
Is this possible?
Thanks
Liz

Yes.

It looks like you are combining all the names in a column, not a row. Where are you getting the data? Is it a query result? Please explain the origin of the data. You can loop through the recordset and then concatenate all the names in a variable like this:

sNamesVar = sNamesVar & "; " & objRS.Names

Or something like that. If you do this after looping through each record, then it will build the string you have.

You may want to look up "Regular Expressions" on msdn for information on concatenating text strings.

HTH


mmcdonal