Jul 12, 2004 #1 MikeRBS IS-IT--Management Joined Apr 15, 2004 Messages 81 Location GB In an Access 200 query, if I do this it works: Slash2: InStr(1,[Filename],".") If I do this it returns zero: Slash2: InStr(1,[Filename],"\") I can only assume some escape sequence is required. Any clues?
In an Access 200 query, if I do this it works: Slash2: InStr(1,[Filename],".") If I do this it returns zero: Slash2: InStr(1,[Filename],"\") I can only assume some escape sequence is required. Any clues?
Jul 12, 2004 #2 amorous Programmer Joined Sep 5, 2003 Messages 1,008 Location US Try this: Slash2: InStr(1,[Filename],"\\") -VJ Upvote 0 Downvote
Jul 12, 2004 Thread starter #3 MikeRBS IS-IT--Management Joined Apr 15, 2004 Messages 81 Location GB Still returns zero. Same with '\\' Upvote 0 Downvote
Jul 12, 2004 Thread starter #4 MikeRBS IS-IT--Management Joined Apr 15, 2004 Messages 81 Location GB I can't believe this. I'd got a completely different field - with no slashes. So Access is just fine after all. If I had a brain, I'd be dangerous... Upvote 0 Downvote
I can't believe this. I'd got a completely different field - with no slashes. So Access is just fine after all. If I had a brain, I'd be dangerous...