M
mgovatos
Guest
I am creating a table in an Access database and I want to create a field that takes information from two other fields in thie record. I have a field called maiden_name and one called last_name, and I want to have a new field called display_name that does one of two things.
1. It fills itself with the contents of maiden_name followed by last_name (with a space in between) if the maiden_name field is not empty or
2 It fills itself with just the contents of last_name if the maiden_name field is empty.
I am thinking there is a way to use expression builder to solve this, but I am not certain how to use this.
Please help.
1. It fills itself with the contents of maiden_name followed by last_name (with a space in between) if the maiden_name field is not empty or
2 It fills itself with just the contents of last_name if the maiden_name field is empty.
I am thinking there is a way to use expression builder to solve this, but I am not certain how to use this.
Please help.