String functions

[posstrap]

I'm using Access 2007. Cant get LEFT to work at all, but thats possibly not necessary. I need to test a field to see if a character is in it, NOT at either end. I've tried Instr([name],len([name]-1)) to get started but no good. Also tried creating a field for the length but it turns it into a parameter ?? e.g. mdstr:len([name]-1) then use [mdstr] in Instr, if that makes sense.


so, if [name] is Simpson I want to know that there is an S in there, and not at either end, then list all [name] that have same parameter
(So easy in dbase) :-)

[RuralGuy]

Sounds like you may have a BOGUS MISSING reference.