In this Microsoft Access tutorial, I'm going to show you how to determine whether or not a specific substring appears inside of another string using the InStr function in a query. It also works in VBA.
Freddy from Arlington, Texas (a Gold Member) asks: My vendor uses a status code that has the characters "DSC" in it if the part has been discontinued. Problem is, that status code also includes a bunch of other random information we don't care about. How can I indicate which parts have that code. I know how to do a search manually, and I know how to do a wildcard search in a query, but that shows ONLY those records. I still want to see all of the rest of them.
LEARN MORE:
599cd.com/InStr
PRE-REQUISITES:
Wildcard Search and LIKE: 599cd.com/Like
Calculated Query Fields: 599cd.com/Calculated
IIF Function: 599cd.com/IIF
LINKS:
String Functions: 599cd.com/String
Microsoft on InStr: tinyurl.com/2ayxfh6l
COURSE:
Access Expert 25 String Functions: 599cd.com/ACX25
BECOME A MEMBER:
KZitem: / @599cd
or My Site: 599cd.com/THMember
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, InStr Function, string within a string, find a character in a string, search for a word, find a substring
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Негізгі бет Use the InStr Function to Find a String Within a String in Microsoft Access
Пікірлер: 21