B
BillA
I have a 'simple' concatenation of 3 fields with a comma before the 3rd
field: "FirstName LastName, Academic"
I would like for the finished string to read; "Jane Smith, PhD"
howevever, I've discovered many records have zero-length strings in the
Academic field and are causing the comma to appear when the Academic field is
blank, e.g:
"Tom Jones,"
This is what I have, which works for most, but not all the records that the
Title field appears blank:
Name: [tbl_Investigator]![FirstName] & " " & [tbl_Investigator]![LastName] &
", "+[tbl_Investigator]![Academic] & IIf(Len([tbl_Investigator]![Academic] &
"")=0,"")
Any advice would be appreciated.
Thank you,
Bill
field: "FirstName LastName, Academic"
I would like for the finished string to read; "Jane Smith, PhD"
howevever, I've discovered many records have zero-length strings in the
Academic field and are causing the comma to appear when the Academic field is
blank, e.g:
"Tom Jones,"
This is what I have, which works for most, but not all the records that the
Title field appears blank:
Name: [tbl_Investigator]![FirstName] & " " & [tbl_Investigator]![LastName] &
", "+[tbl_Investigator]![Academic] & IIf(Len([tbl_Investigator]![Academic] &
"")=0,"")
Any advice would be appreciated.
Thank you,
Bill