Here's my question, and it's a rather simple one, and I'm drawing a total blank. I've been out of the loop with creating databases via access for some time and I'm afraid I've forgotten quite a bit.
What I need to do is this.
Join [Name1] with [Name2] with an & only if name 2 is not null. If it is null, just show the first name.
Example
[Name1] = John Doe, Sr.
[Name2] = Jane Doe
John Doe, Sr & Jane Doe
[Name1] = John Doe, Sr.
[Name2] = (empty)
John Doe, Sr.
Thank you for the assistance.
What I need to do is this.
Join [Name1] with [Name2] with an & only if name 2 is not null. If it is null, just show the first name.
Example
[Name1] = John Doe, Sr.
[Name2] = Jane Doe
John Doe, Sr & Jane Doe
[Name1] = John Doe, Sr.
[Name2] = (empty)
John Doe, Sr.
Thank you for the assistance.