Topic: ||

For testing I made 1 database with 3 fields and 1 calculated field. The formula for the calculated field is: testtabel.Naam||', '||testtabel.Roepnaam||' '||testtabel.Tussenvoegsel.

When in the database all the 3 fields are populated, the calculated field is also populated correct. But when I leave one of the 3 fields empty, the calculated field is also completely empty.

What do I wrong, or is the formula for the calculated field not possible?

2 (edited by derek 2018-01-21 12:31:31)

Re: ||

Hi Akkerhof,
Try it like this:
ifnull(naam,'')||' '||ifnull(roepnaam,'')||' '||ifnull(tussenvoegsel,'')
Please see the attachment for a working example.
Regards,
Derek.

Post's attachments

Attachment icon akkerhof.zip 336.29 kb, 555 downloads since 2018-01-21 

Re: ||

Hi Derek, Thanks very much for your quick solution. Have a nice day.