Find Records by Email Domain in a Microsoft Access Query
Question details
Find people whose email addresses use a specified domain, even when the table has no numeric identifier.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The user wants to filter a table of people by an email domain such as gmail.com.
- Observed behavior
- The query should return matching people based on their email addresses without requiring a numeric ID.
Open the database in Microsoft Access and identify the table and field that contain email addresses. Check the actual field name before using it in a calculated expression.
Filter email addresses with a Like criterion
Use this method to return people whose email addresses end in a specific domain.
In Access, select Create > Query Design, add the table containing the email addresses, and close the table-selection window.
Double-click the email field and any fields you want to see, such as the person's name, to add them to the query grid.
In the Criteria row under the email field, enter Like "*@gmail.com". Replace gmail.com with the domain you want to find.
Select Run on the Query Design ribbon to display the matching records. A numeric identifier is not required.

Extract email domains for sorting or grouping
Create a calculated field when you want to work with domains separately from full email addresses.
Review exported email lists with WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface and compatibility with Microsoft Office files for easier migration. You can review an email list exported from Access in WPS Spreadsheets, but WPS does not run or repair Microsoft Access queries.

Frequently Asked Questions
Do I need an ID field to filter by email domain?
No. In Query Design, add the email field and enter Like "*@gmail.com" in its Criteria row. Include any other fields you want to display.
Why does the asterisk wildcard not return results?
Check whether the database uses ANSI-92 query syntax. If it does, enter Like "%@gmail.com" in the email field's Criteria row instead. Also verify the domain spelling and email values.
Will the criterion match addresses at subdomains?
Like "*@gmail.com" matches addresses ending in @gmail.com; it does not match an address such as name@mail.gmail.com. Use a separate criterion if subdomains must be included.
How can I count records by email domain?
Add the calculated Domain field and the email field to a query, then select Totals on the Query Design ribbon. Set the Total row to Group By for Domain and Count for the email field, then select Run.




