>Sorry, I am using FPW26 and if I use the SQL, I end up getting the same data. If I have duplicate code+size, it will probably eliminate it.
>
>Tai SC
>
Looking at the output you wanted, it does not look like you want counts. So duplicate records not being included should not matter. Carl's solution should still work unless you are trying to count something.
>
>>Using the built-in VFP5.0a query designer, I ended up with the data the way you pictured it, except the 1, 2, and 3 were shown as C_1, C_2, and C_3. I know there's a way to get it back to what you want, but I can't think what it is this late. :)
>>
>>However, the SQL code to get that data doesn't seem to care that it's not numeric:
>>
>>SELECT *;
>> FROM size;
>> GROUP BY Size.code, Size.size;
>> ORDER BY Size.code, Size.size;
>> INTO CURSOR SYS(2015)
>> DO (_GENXTAB) WITH 'Query1'
>>BROWSE NOMODIFY
>>
>>Give it a shot, it worked for me.
Mark McCasland
Midlothian, TX USA