I'm trying to create a field for current location that will change the inventory item to the new location based on what type of transaction is made. The three locations are Warehouse, Employee, Removed. The 4 types of transactions are Issued, Returned, Addition, Removed
Below is the code that I'm trying to use, but its returning a error code of invalid syntax "you have entered an operand without and operator"
Any help would be appreciated.
Code:
Current Location: IIf([Transaction Types].[Add/Remove]="Addition" Or [Transaction Types].[Add/Remove]="Returned","Warehouse",IIf(Transaction Types].[Add/Remove]="Issued","Employee","Removed"))