Just to be clear...is EQ1NAME the name of a field that exists in the table? IOW, it is not a variable that contains the name of a field.
>Steve,
>
>Typically EQ1 through EQ16 would have .F. or .T. (obviously).
>EQ1NAME through EQ16NAME are C-type fields of 20 char long. They maybe blank or some could have entries. For example, user looks at a form where he/she sees all equipment available and check box to select what he/she wants:
>EQ1NAME EQ1
>EQ2NAME EQ2
>... and so on.
>
>On the report I need to show the selected equipment in a column, excluding all the ones thate were not selected. That's why I need the SQL select.
>
Steve Gibson