Hello,
I am relatively new to Access and just figuring out a lot of this. I am using a query to concatenate first and last names for a group of people. I have had no trouble doing this, but now I’d like to add a title to some people’s names if they possess that title. I have a yes/no field for the title but I don’t know how to include that in the concatenation. So, for example, if the checkbox in the column ‘Leader’ is checked, I’d like the name to be FirstName LastName, Leader. But if it is unchecked, I’d like it be just FirstName LastName. I know this needs an IIF statement, but I just can’t seem to create a formula that works. Can anyone suggest a solution to this? Thank you so much!
I am relatively new to Access and just figuring out a lot of this. I am using a query to concatenate first and last names for a group of people. I have had no trouble doing this, but now I’d like to add a title to some people’s names if they possess that title. I have a yes/no field for the title but I don’t know how to include that in the concatenation. So, for example, if the checkbox in the column ‘Leader’ is checked, I’d like the name to be FirstName LastName, Leader. But if it is unchecked, I’d like it be just FirstName LastName. I know this needs an IIF statement, but I just can’t seem to create a formula that works. Can anyone suggest a solution to this? Thank you so much!