Re: InStr does not return position of $ symbol



It will work, provided that the field 'Specifier' does actually contain the
'$' character, rather than being formatted to appear as though it does.

What is the data type of the 'Specifier' field?

--
Brendan Reynolds
Access MVP

"Ron - CLH" <Ron - CLH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:77ABBACC-B876-4897-8CEC-0FDB4339BC8D@xxxxxxxxxxxxxxxx
InStr does not return position of $ symbol: InStr([Specifier],Chr(36)).
How
else can I do this in an Access 2002 query?


.



Relevant Pages

  • Re: [PHP] newbie question
    ... padding the results to the right string size. ... This may be a space character ... a width specifier that says how many characters ...
    (php.general)
  • Re: [PHP] newbie question
    ... padding the results to the right string size. ... This may be a space character ... a width specifier that says how many characters ...
    (php.general)
  • Re: reading variably sized floats
    ... It's supposed to be the f5.2 specifier. ... In the input file the line being read is: ... The tab character is just a character and is counted as 1 when using ... Most COMPILERS will adjust for the tab character in the SOURCE ...
    (comp.lang.fortran)
  • Re: question on character-like variable defination
    ... In a character declaration, the length of the strings is specified ... type name itself or as a specifier on each variable being declared. ...
    (comp.lang.fortran)
  • Re: question on character-like variable defination
    ... James Giles wrote: ... type name itself or as a specifier on each variable being declared. ... The default length is one character. ... obsolescent. ...
    (comp.lang.fortran)