If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Firstname plus Middlename??
John Spencer wrote in
: You have made an error in your expression. " " & MiddleName will always return at least a space. The plus sign will see the space and return it. If you wanted to be safe you could use [surname] & ", " & [firstname] & (" " + [middlename]) Although you could still end up with extra spaces if firstName and middlename are null you would end up with Spencer, and a space. "Spencer, " This solves all the possibilities: Mid(("12"+[LastName]) & (", "+(Trim([FirstName] & (" "+[MiddleName])))),3) -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
|
Thread Tools | |
Display Modes | |
|
|