> 1) SELECT space(10) as FIELD1, ; > space(20) as FIELD2, ; > 0000.00 as CField1 ; > FROM TABLEA ; > WHERE .F. > UNION ALL > SELECT FIELD1, ; > FIELD2, ; > SUM(value) as CField1 ; > etc. > > The first SELECT will create the structure with no information. The > second SELECT will populate the structure. This means that you have to > know the size of all of the fields before you start. Thank you VERY MUCH for your message. Especially for the trick above. This problem was driving me nuts.