- Joined
- Feb 27, 2006
- Messages
- 1
- Reaction score
- 0
Hope someone can help. I am trying to combine an IIF statement with a Dlookup, what I'm trying to do is verify the contents of a column match those in another tables column I have
IIF(DLookUp(([Code1]),[table1].[loopup],0),RIGHT(Code1,LEN(Code1)-1),Code1)
Whih is wrong for a number of reasons I guess as it keeps asking me for [table1].[lookup] value.
Can someone tell me where I am going wrong???
IIF(DLookUp(([Code1]),[table1].[loopup],0),RIGHT(Code1,LEN(Code1)-1),Code1)
Whih is wrong for a number of reasons I guess as it keeps asking me for [table1].[lookup] value.
Can someone tell me where I am going wrong???