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?