Isaac
Lifelong Learner
- Local time
- Today, 05:02
- Joined
- Mar 14, 2017
- Messages
- 8,777
Can anyone spot where my "syntax error" is? Only gets raised when I try to Run the query, not when I tab out of the column field
In this case [View History] is another column (to the left) in the query. so is COBOx
Code:
HasViewed_COBO: IIf(InStr(1,[View History],[COBOx])>0,"Yes","No")
In this case [View History] is another column (to the left) in the query. so is COBOx