IF INLIST("Y",my_field1,my_field2,my_field3.....on to whatever
>I am looking for a shortcut way to do this.
>Thanks in advance and then some.
>
>IF mytable.my_field1 = "Y" OR ;
> mytable.my_field2 = "Y" OR ;
> mytable.my_field3 = "Y" OR ;
> mytable.my_field4 = "Y" OR ;
> mytable.my_field5 = "Y" OR ;
> ...(do whatever)
>ENDIF
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05