>>>>In vfp60, Is there a way to SUM alike records with a SELECT statement?
>>>>I have a table with a field called part_number. This table is ORDER BY part_number...There are many records that contain the same
>>>>part_number values and I want to SUM these records so I have
>>>>a DISTINCT on part_number and the part_number values will be totaled and represented in one record for each part_number...any ideas?
>>>
>>>select part_number, sum(numfield) as myTotal from mytable group by part_number
>>>Cetin
>>--------
>>Hi Certin....Nice to hear from you again...my numfidld is non-numeric...
>>and the SUM will not work...:)
>
>Thanks Rob. Then what will you sum ? You mean something like distinct row or what ? Or you mean a cross-tab ?
>Cetin
---------
Cetin, I got it now...I was not thinking again....I group by part_number
and sum some fld....thanks.....:)