This topic is locked
[SOLVED]

 Lookup Wizard with 2 conditions in Where expression

9/18/2011 11:52:07 AM
ASPRunnerPro General questions
D
dorlisa author

Hi All,
I have a field that looks up folks in my "roster" table and displays there name to select from.
I added this "Where" statement ("Title = 'ASOM'") to identify these folks by there title and it works, but I need to add a second condition in that "Where" expression.
I added this ("Title = 'ASOM'" OR "Title2 = 'ASOM'") and it doesn't work.
Can you tell how I can get field to list folks who have the same title whether it's in "Title" or "Title2"?
Thanks,

aspnewbie

J
jmclain 9/18/2011

I have not had time to test but try this . . .

"Title = 'ASOM' OR Title2 = 'ASOM'"
D
dorlisa author 9/18/2011

Thanks Die Hard, that worked perfectly.