And your goal is to have one very long field that contains all of those results, separated by semi-colons?
>Yes, EQ1NAME .. EQ16NAME are fields in a table.
>
>>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