A
AccessNovice
How do you write an IF statement in a report involving multiple fields when
not all of the fields have data in them?
Here are my fields: Mr/Ms, FirstName, MiddleName, LastName, Jr/Sr
I would like the end result to look like: Mr. John Q. Public, Jr.
Sometimes a record doesn't have a middle name, sometimes it doesn't have a
"Jr.", etc. No matter how I try to write the statement, I seem to be leaving
something out; or it returns extra spaces on the line.
not all of the fields have data in them?
Here are my fields: Mr/Ms, FirstName, MiddleName, LastName, Jr/Sr
I would like the end result to look like: Mr. John Q. Public, Jr.
Sometimes a record doesn't have a middle name, sometimes it doesn't have a
"Jr.", etc. No matter how I try to write the statement, I seem to be leaving
something out; or it returns extra spaces on the line.