I have a table in Access 2010 based on these fields:
ID Subdivision Builder Lessor Resident
In the 500 records, one of the last 3 fields (Builder, Lessor or Resident) must be populated, and is. However, I want to combine all 3 by simply creating a field called "Owner". In the query design I want to create a field by using an expression that says CST Owner = Builder OR Lessor OR Resident.
Would that require an IIf statement that says if Builder is null, then use Lessor; if not, use Resident? Is that how it works? If so, can you help me with the syntax?
ID Subdivision Builder Lessor Resident
In the 500 records, one of the last 3 fields (Builder, Lessor or Resident) must be populated, and is. However, I want to combine all 3 by simply creating a field called "Owner". In the query design I want to create a field by using an expression that says CST Owner = Builder OR Lessor OR Resident.
Would that require an IIf statement that says if Builder is null, then use Lessor; if not, use Resident? Is that how it works? If so, can you help me with the syntax?
