yeah, just looked at help. since your first value is a number, it is thinking that you want to START looking at that location in your string. Make it a string and the error will go away.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 19 Jun 2009 at 7:13am
'other criteria and
instr(...)>0
you did add the >0? just checking, I was after the syntax. Otherwise I am at a loss. Maybe some other part of the criteria is failing? Try commenting out parts and see if that narrows down where the error is occurring.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
