I know I've seen something way more elegant than this:
if ADivision <> 1 and ADivision <> 5 and ADivision <> 12 and ADivision <> 15 and ADivision <> 17 then
can anyone please help me remember how to make a list of values and use the equivalent of IN?
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases: The Fundamentals of Relational Database Design
if ADivision <> 1 and ADivision <> 5 and ADivision <> 12 and ADivision <> 15 and ADivision <> 17 then
can anyone please help me remember how to make a list of values and use the equivalent of IN?
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases: The Fundamentals of Relational Database Design