Hi everyone. I look forward to helping when I can & being helped as I stretch my skills into some SQL/VBA programming.
so riddle me this:
The idea here is to create labels that concatenate Person1 & Person2 appropriately and simultaneously accommodate records where there is only Person1 without producing a trailing '&' on records with only Person1
results in the query
CN: [fname1] & " " & [lname1] & " & " & [fname2] & " " & [lname2]
So then my feeble reach below produces a missing operator error:
SELECT tblMailing.*, If IsNull [FName2]& " " &[LName2] Then
[FName1]& " " &[LName1]
Else [FName1]& " " &[LName1& " &" &[FName2]& " " &[LName2]
-am I close or waaaay off?
so riddle me this:
The idea here is to create labels that concatenate Person1 & Person2 appropriately and simultaneously accommodate records where there is only Person1 without producing a trailing '&' on records with only Person1
results in the query
CN: [fname1] & " " & [lname1] & " & " & [fname2] & " " & [lname2]
So then my feeble reach below produces a missing operator error:
SELECT tblMailing.*, If IsNull [FName2]& " " &[LName2] Then
[FName1]& " " &[LName1]
Else [FName1]& " " &[LName1& " &" &[FName2]& " " &[LName2]
-am I close or waaaay off?