Others

Find Records by Email Domain in a Microsoft Access Query

John WilsonJohn Wilson Nov 20, 2026 869 views

Question details

Find people whose email addresses use a specified domain, even when the table has no numeric identifier.

Find Records by Email Domain in a Microsoft Access Query
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.
Before you start

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.

Solution 1Recommended

Filter email addresses with a Like criterion

Use this method to return people whose email addresses end in a specific domain.

1
Create a query

In Access, select Create > Query Design, add the table containing the email addresses, and close the table-selection window.

2
Add the fields

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.

3
Enter the domain criterion

In the Criteria row under the email field, enter Like "*@gmail.com". Replace gmail.com with the domain you want to find.

4
Run the query

Select Run on the Query Design ribbon to display the matching records. A numeric identifier is not required.

Filter email addresses with a Like criterion
Wildcard setting: The asterisk wildcard is used in standard Access queries. If the database uses ANSI-92 query syntax, use Like "%@gmail.com" instead.
Free Microsoft Office alternative

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.

Review and filter exported email lists in a spreadsheetCompatible with Microsoft Excel XLSX and XLS filesFamiliar spreadsheet interface for Office usersFree and lightweight office suite
microsoft office alternative - wps office

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.