Hallo nochmal,
in SQL würde das dann so aussehen:
SELECT Tabelle1.Text1, Tabelle1.Text2, Tabelle1.Text3, Tabelle1.Text4, IIf([Text1]="" And [Text3]="" And [Text2]="" And [Text4]="","",[Text1]+"."+" " & [Text2]+"."+"" & [Text3]+"."+"" & [Text4]) AS Zusammenführen, IIf([Text1]="" And [Text3]="","",[Text1]+"."+" " & [Text3]) AS Ausdr1, IIf([Text1]="" And [Text3]="" And [Text2]="" And [Text4]="","",[Text1]+"."+" " & [Text2]+"."+"" & [Text3]+"."+"" & [Text4]) AS Ausdr2
FROM Tabelle1;
Gruß
Paul1