Find a string within a string

S

shank

I'm strying to update a field based upon the type of email address is in
another field.
In short, if anyone has an email domain like what's in
[DomainString]![DomainString] (below), I'm update with either Text or HTML.
However, I'm not having much luck. I've tried StrComp, InStr, and now
InStrRev.
Anny thoughts?
thanks!

IIf(InStrRev([Import
List]!,[DomainString]![DomainString]>0),"Text","HTML")


[DomainString]![DomainString] has these strings for comparison
@aol.com
@juno.com
@msn.com
@yahoo.com
 
J

Jen

Hi There,

Should be....

IIf(InStrRev([ImportList]!,[DomainString]!
[DomainString]) > 0,"Text","HTML")

Those darned parenthesis will get you every time...

Regards,
Jen
 
Top