hOW ABOUT:
IF "Y"$mytable.my_field1 +mytable.my_field2+mytable.my_field3+mytable.my_field4+mytable.my_field5
do something
endif
>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
Peter Cortiel