>IF INLIST("Y",my_field1,my_field2,my_field3.....on to whatever
Heh -- didn't think this would work until I tried it. I always use INLIST() the other way -- IF INLIST(lcMonth, "January", "February", "etc...").
One problem: if my_fieldn is wider than 1, it will fail with SET EXACT OFF, but it will work with SET EXACT ON.