Combining Text Fields
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:
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?