Query to find text position

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(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.
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Text in a Query 5
Splitting Text in a Field Based on a Delimiter 2
Text Positioning 2
Query Parameter using multiple options 0
Access Dcount (multiple criteria) 3
Update query to set value based on position in recordset 2
Data Mismatch in Excel 2010 4
Return a value from a record based on the record's position in a q 2

Back
Top