Wildcard Searches with the LIKE Keyword in Microsoft Access Queries - Find Specific Email Domains
Автор: Computer Learning Zone
Загружено: 2020-11-29
Просмотров: 11304
Learn how to perform wildcard searches using the LIKE keyword and the special characters (*,?,#) in your Microsoft Access queries. In this example, I'll show you how to find email addresses at specific domains, like @gmail.com.
Xavier from Bury St Edmunds, England (a Gold Member) asks: I need to create a report to show all of my customers who have email addresses in a few specific domains like Gmail and Yahoo. How can I do that?
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to search in a list or range of characters, exclude specific characters, and search for the actual wildcard characters inside your strings.
MEMBERS ONLY VIDEO:
• Wildcard Searches with the LIKE Keyword in...
BECOME A MEMBER:
/ @599cd
LINKS:
Get on my Mailing List: https://599cd.com/YTML
What is a Query: • What is a Query in Microsoft Access? How t...
Everything About Queries: https://599cd.com/441
Query Criteria: https://599cd.com/1325
Wildcards Covered in Class: https://599cd.com/ACB5
ADDITIONAL RESOURCES:
FREE Access Level 1: https://599cd.com/Free1
FREE Blank Customer Template: https://599cd.com/FRL2
$1 Access Level 2: https://599cd.com/1Dollar
TechHelp: https://599cd.com/TechHelp
Twitter: / learningaccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: amicron@gmail.com
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, examples of wildcard characters, like keyword, searching for special characters, search for email domains, using wildcards in queries, wildcard filter and searches, how to create a wildcard query in microsoft access, access wildcard query, like condition, like keyword, special characters, like operator, how do you use like in ms access, ms access like criteria, ms access like query parameter, ms access wildcard in parameter query
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: