Another Question.

pbecker13

Registered User.
Local time
Today, 13:41
Joined
Mar 6, 2007
Messages
12
I have an email field. Lots of things have been typed into it for some reason, that I can't go back and change, so in my query I want only the ones containing "@" to show up. I think it can be done, but that it will totally exclude the records without an @, but I still need them to show up, just with a blank email field. Is this possible. :confused:
 
Create a new field in your query and set it like this:

EmailAddress: IIf(InStr(1,[YourEmailFieldNameHere],"@")>0,[YourEmailFieldNameHere],"")
 

Users who are viewing this thread

Back
Top Bottom