Sorting e-mail addresses

A

Anna Sargent

I have a large list of e-mail addresses.

How can I sort and retrieve only those with @aol.com

thank you,
ams
 
K

Kevin @ 3NF

Select emailfield
from your table
where emailfield like "*" & "@aol.com"
order by emailfield
 
J

John Vinson

I have a large list of e-mail addresses.

How can I sort and retrieve only those with @aol.com
Click to expand...

"Sorting" and "retrieving" are two different issues: to Sort means to
take the records and put them into an alphabetic or numeric sequence.

To search for addresses from AOL, use a Query based on your table. As
a criterion on the EMail field use

LIKE "*@aol.com"

The * is a wildcard meaning "any string of characters".

To sort the addresses alphabetically, just put Ascending on the Sort
row of the query grid.
 
Top