I know there is a simple solution to this but I cannot figure this out. I need to create a new field in a query that shows data for one field, but if it is null, shows another field, and if THAT field is null, shows a 3rd field. I can get this to work for 2 of them by adding the language below in the field name:
NewFieldName: IIf(tblemployees2.COMPANY is not null,tblemployees2.COMPANY,tblconsultants.COMPANY)
As you can see I have 2 tables with identical field names. This string compares one field with another and if the first is null, uses data from the 2nd.
I tried adding the 3rd field in the same fashion but it will not work. I keep getting errors everywhere.
Please help!
Thank you!