Simple task for you pros I am sure

[Scadadude]

Hi, I have a simple table with contact info with a column their email addresses. If I wanted to perform a query that pulled out all the @aol.com email address how would I do that?

Thanks

Scadadude

 

[David Eagar]

Query criteria like "@aol"

 

[MSAccessRookie]

Hi, I have a simple table with contact info with a column their email addresses. If I wanted to perform a query that pulled out all the @aol.com email address how would I do that?

Thanks

Scadadude

Read up on the instr() command, because I believe that it will help find the records you are looking for. You can use it to select the records containing "@aol.com"

 

[dkinley]

Suppose the field name was "email". In the QBE for the column of the email, put the following in the critieria row.

Right([email],8)="@aol.com"

-dK

EDIT: Cross posted. I went for specifics, but David's will work no problem and probably catch those partial or incomplete addresses with the following tweak ..

Like "*aol*"

 

[MSAccessRookie]

Query criteria like "@aol"

If you are going to use the "Like" method, use *@aol* instead, because the @aol will return records where the address contains only @aol. The "*" characters allow for wildcard processing.

 

[Scadadude]

Doesnt work, comes back with a blank table. I did confirm there were @aol.com email addresses in the column.

 

[MSAccessRookie]

Notice how even a "Simple Task" has so many different options regarding methods for completion. Now all you have to do is choose the one that suits you the best.

 

[MSAccessRookie]

Doesnt work, comes back with a blank table. I did confirm there were @aol.com email addresses in the column.

What doesn't work? You have been given three choices so far.

 

[Scadadude]

Works great I knew you guys would know what to do.

Thanks

Scadadude

 

[MSAccessRookie]

Works great I knew you guys would know what to do.

Thanks

Scadadude

Which solution suited you the best?

 

[Scadadude]

This is a work in progress for now the "LIKE" method will work I read up a b itit on the InStr() method and I think when my table is complete that method will work best but I havent tested it yet.

Scadadude