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.
 
Back
Top