Query to capture AOL accounts

Thread view:

Thread rating:

Glenn Dulmage - 20 Apr 2008 00:36 GMT

I have a table which has an E-MAIL field. I would like to select all those
e-mail addresses that are ??????@aol.com.

How can I do this?

Signature

Glenn

Glenn T. Dulmage
207 Valley Road
Chestertown, MD 21620
410-778-5166
gdulmage@verizon.net

Duane Hookom - 20 Apr 2008 02:47 GMT

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

Signature

Duane Hookom
Microsoft Access MVP

> I have a table which has an E-MAIL field. I would like to select all those
> e-mail addresses that are ??????@aol.com.
>
> How can I do this?

Glenn Dulmage - 20 Apr 2008 15:47 GMT

Thanks Duane. Worked like a charm.

Glenn

> Try set the criteria under the Email field/column to:
> Like "*@aol.com"
[quoted text clipped - 4 lines]
>>
>> How can I do this?