Data from table into text object

[#1]

Hi all,

Trying to place some text into from a table into a text object. I need all text (from 2 fields) from the table in the text object.

Something like

= field1 & ' ' & field2

But I need all text not just based on a selection. So something like:

= {1} field1 & ' ' & {1} field2

But I am getting errors.

Any ideas?

Regards

Revlin

[swuehl]

You'll need an aggregation function here, like concat:

=concat( {1} field1 & ' ' & field2, ', ')

[#3]

Yes that works. Thank you.