Escape sequence for backslash

[MikeRBS]

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?

 

[amorous]

Try this:

Slash2: InStr(1,[Filename],"\\")

-VJ

 

[MikeRBS]

Still returns zero. Same with '\\'

 

[MikeRBS]

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...