Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help - Query Formula 1

Status
Not open for further replies.

RDM23

Technical User
May 16, 2007
39
US
I am writing an Access query where I want to query records in a certain pattern. An example of one name is ILT-QM-SAP-0007. I know that the first letters ILT will always be in the field name, and the 3rd set, SAP, will always be in the field name. Is there a way to write a formula that would pull back any records where first set of numbers is ILT, and 3rd set of numbers is SAP. Thanks in advance for any assistance.
 
Like 'ILT-*-SAP-*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top