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.
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 Mike Lewis 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
- Thread starter RDM23
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
