Query to capture AOL accounts

[Glenn Dulmage]

I have a table which has an E-MAIL field. I would like to select all those
e-mail addresses that are [email protected].

How can I do this?

--

Glenn

Glenn T. Dulmage
207 Valley Road
Chestertown, MD 21620
410-778-5166
(e-mail address removed)

 

[Duane Hookom]

Try set the criteria under the Email field/column to:
Like "*@aol.com"

 

[Glenn Dulmage]

Thanks Duane. Worked like a charm.

Glenn

Try set the criteria under the Email field/column to:
Like "*@aol.com"