Recent content by mogodia

Dear pbaldy...it worked exactly as you suggested & by struggling & studying this I managed to bring all three conditions combined into one field. Here it is: cn: IIf([lname1]=[lname2],[fname1] & " & " & [fname2] & " " & [lname1],IIf([fname1]+[lname1],[fname1] & " " &...

hey dcrake- Yes these requests & diversity in naming can get quite complex. Your answer looks like an artform!! It will take me a couple of days to work through this & test. Thank-you very much & I will be in touch soon. -many thanks!

morning coffee helps! the following returns correctly in three separate fields respectively: cn: IIf([lname1]=[lname2],[fname1] & " & " & [fname2] & " " & [lname1]) (this successfully returns: anna & doug smith) cn2: IIf([fname1]+[lname1],[fname1] & " " & [lname1]) (this successfully returns...

new day...some sleep..more clarity: =IIF ([lname1]=[lname2],[fname1]& “ & “ &[fname2]& “ “ &[lname1],IIF([fname1]+[lname1]+[fname2]+[lname2], [fname1] & " " &[lname1] & (" & " + [fname2] + " " + [lname2])) still working on this

o' dear pbaldy! I am completely lost. CN: IIf([lname1]=[lname2],[fname1] & (" & "+[fname2] & " " & [lname1]& ("& "+[fname1]+" "+[lname1]+" "+[fname2]+" "+[lname2])) but now it ignores the fname1 & lname1 (leaves it blank) and then this: anna & doug smith anna smith & doug smith in the same...

So Paul- ok, nothing like end user requests! In addition to the concatenation tips you helped me with above...how would you consider this: My end users want this: if Lname1=lname2, then concatenate fname1 & fname2 with lname1 (so bill smith & diane smith will become Bill & Diane smith) Can...

Dear PBaldy- It works like a CHARM! So simple...so elegant & so SUBTLE a change with big results! Thank-you also for your remarks about syntax...syntax is more persnickety than grammar and it is igniting my curiosity. -many thanks

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...