By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 992 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

criteria in query part of field text only

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 30 May 2004 09:49:17 -0700, MemphiDoug wrote:
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


If "aol.com" is only at the end of the field:
Like "*aol.com"

If "aol.com" can be anywhere in the field:
Like "*aol.com*"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.