If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
criteria in query part of field text only
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 |
#2
|
|||
|
|||
criteria in query part of field text only
Assuming your email field contains something like , 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "MemphiDoug" wrote in message m... 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 |
Thread Tools | |
Display Modes | |
|
|