>I am looking for a shortcut way to do this.
>Thanks in advance and then some.
>
>IF mytable.my_field1 = "Y" AND ;
> mytable.my_field2 = "Y" AND ;
> mytable.my_field3 = "Y" AND ;
> mytable.my_field4 = "Y" AND ;
> mytable.my_field5 = "Y" AND ;
> ...(do whatever)
>ENDIF

In addition to Cindy's suggestion, if these are all single character fields, you could use:

MYTABLE.MY_FIELD1 + MYTABLE.MY_FIELD2 + ... = "YYYY..."

Doug