criteria in query part of field text only

  • Thread starter Thread starter MemphiDoug
  • Start date Start date
M

MemphiDoug

In my email field, I want to query only the aol.com users. I have
tried ="*[aol.com]*", I have tried LIKE "*[aol.com]*", I have tried
just "aol.com" I can't figure out how to have it give me only the
people that have "aol.com" as part of their field entry in my email
field. Help?

Doug
 
Assuming your email field contains something like (e-mail address removed), you want
LIKE "*aol.com*" (assuming you're using DAO), or LIKE "%aol.com%" (if you're
using ADO).

The square brackets you're including aren't required.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 2007 "To: field" problem with pgm using MAPI 1
combining the answers to queries 1
Find something in any field 4
Sub query combining fields 1
Compare two tables for matching criteria 3
Outlook 2000 took AOL emails and won't give them back! 2
Null Values 3
Sort a column (specifically email data) by end of text, not beginn 4

Back
Top