I have two fields. One called "Mobile" and another called "PersonalCellular"
I'm trying to write a query where if the Mobile field is empty, it would be populated with the PersonalCellular field. So I tried this,
This results in an error message that reads, "Circular reference caused by alias 'Mobile' in query definition's SELECT list"
This is because the field Mobile is an actual field in the table. So I then tried this:
This works fine. But I don't want to see MobileX in the results since I'm exporting the query to a spreadsheet which needs to have a column called Mobile (not MobileX).
Is there any other way to be able to do this?
I'm trying to write a query where if the Mobile field is empty, it would be populated with the PersonalCellular field. So I tried this,
Code:
Mobile: IIf(IsNull([Mobile]),[PersonalCellular],[Mobile])
This results in an error message that reads, "Circular reference caused by alias 'Mobile' in query definition's SELECT list"
This is because the field Mobile is an actual field in the table. So I then tried this:
Code:
MobileX: IIf(IsNull([Mobile]),[PersonalCellular],[Mobile])
This works fine. But I don't want to see MobileX in the results since I'm exporting the query to a spreadsheet which needs to have a column called Mobile (not MobileX).
Is there any other way to be able to do this?