Query to find text position

C

Carol Giannini

(1) Is there a query function that will return the starting position of
specified text within a field? FIND and SEARCH don't seem to work in
queries. (2) Is there a reference that defines all of the query functions,
what they do and how to use them? As always, thank you.
 
J

Jeff Boyce

Carol

Check Access HELP on the InStr() function ("in-string"). The syntax goes
something like:

InStr([YourField],"z")

to return the position of the first "z" in the [YourField] field.
 
C

Carol Giannini

Thank you *very* much.

Jeff Boyce said:
Carol

Check Access HELP on the InStr() function ("in-string"). The syntax goes
something like:

InStr([YourField],"z")

to return the position of the first "z" in the [YourField] field.

--
Good luck

Jeff Boyce
<Access MVP>

Carol Giannini said:
(1) Is there a query function that will return the starting position of
specified text within a field? FIND and SEARCH don't seem to work in
queries. (2) Is there a reference that defines all of the query functions,
what they do and how to use them? As always, thank you.
Click to expand...
Click to expand...
 
Top