A Anna Sargent Jul 21, 2003 #1 I have a large list of e-mail addresses. How can I sort and retrieve only those with @aol.com thank you, ams
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 Jul 21, 2003 #2 Select emailfield from your table where emailfield like "*" & "@aol.com" order by emailfield
J John Vinson Jul 21, 2003 #3 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.
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.
