How do I directly Concatenate data using a Base form

[shaneo1]

I have a form in Base that holds customer data and I would like to use a textbox or formatted field, to pull in firstname and surname, so that I can make a sentence containing the fields from a table.

eg 'The data on this form belongs to ’

I know how this is done using a query, but not directly using the forms, unbound field.

Any help would be great

[qubit1]

Hi @shaneo1,

Still looking for an answer here?

[mahfiaz]

Althought I haven’t exactly tried it, but it is highly likely, that

SELECT COALESCE(field1, '') || COALESCE(field2, '') || COALESCE(field3, '') FROM table1

would do the trick. Copied from here: http://stackoverflow.com/questions/6427764/concatenate-two-database-columns-into-one-resultset-column