Sorting e-mail addresses

[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

 

[Kevin @ 3NF]

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

 

[John Vinson]

I have a large list of e-mail addresses.

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

"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.