I am trying to write an expression for the following fields:
Date
Customer
Job_Number
Product
System
Revenue
Category
Team
The expression that is giving me the error message is:
TEAM: IIf([CATEGORY]="EAST" And [PRODUCT]="SURFACE_PREP" And [SYSTEM]="WATERBLAST","BIRMINGHAM","HOUSTON")
The error message says: "The specified field '[SYSTEM]' could refer to more than one table listed in the FROM clause of your SQL statement."
I've searched this forum as well as Access Help and can't figure out what's causing this error. Any help would be greatly appreciated!!
Thanks!