Ask Your Question
1

How do I directly Concatenate data using a Base form [closed]

asked 2012-09-16 18:34:33 +0200

shaneo1 gravatar image

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 <firstname> <surname>'

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

Any help would be great

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-31 16:22:56.882159

Comments

Hi @shaneo1,

Still looking for an answer here?

qubit gravatar imagequbit ( 2013-04-27 20:23:12 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2013-05-13 13:03:39 +0200

mahfiaz gravatar image

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

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-09-16 18:34:33 +0200

Seen: 1,433 times

Last updated: May 13 '13