I have a table with a field
.[LOBManager] and I need 2 queries where in 1 I need find out if the record has one of these values and another where the record does not contain any of the values.
Values = “Cheri West", "John Smith", "Peter Brown, III"
I tried:
In “Cheri West" Or "John Smith" Or "Peter Brown, III"
The SQL showed this:
In(([Table1].[LOBManager])="Cheri.West" Or ([Table1].[LOBManager])="John Smith" Or .... for the 3rd name it split it out into 2 names, one being the III.
And bottom line I get an error "data type mismatch in criteria expression". The field name fields are short text.
I'm sure the name with III will probably need a &?
Is there another way to do this beside "In"?
And how would I code it as Not In?
Appreciate the help!
Values = “Cheri West", "John Smith", "Peter Brown, III"
I tried:
In “Cheri West" Or "John Smith" Or "Peter Brown, III"
The SQL showed this:
In(([Table1].[LOBManager])="Cheri.West" Or ([Table1].[LOBManager])="John Smith" Or .... for the 3rd name it split it out into 2 names, one being the III.
And bottom line I get an error "data type mismatch in criteria expression". The field name fields are short text.
I'm sure the name with III will probably need a &?
Is there another way to do this beside "In"?
And how would I code it as Not In?
Appreciate the help!