>>Assuming that you want to sum a field such as Quantity, you could use something like this.
>>
>>
>>SELECT MyTable.Part_Number, sum(MyTable.Qty) as Qty ;
>> FROM MyTable ;
>> GROUP BY MyTable.Part_Number ;
>> ORDER BY MyTable.Part_Number
>>
>>The Group by will create one record for each part number.
>>
>>>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?
>----------------
>Hi Norm...looks good, but my part_number is a non-numeric field...
The part number does not need to be numeric. It is only the field that you are grouping the totals by. When you say that you are wanting to sum like records, aren't you trying to sum a numeric field with the total by the part_number?
____________________________________________
Norm Peterson
It's a dog eat dog world out there,
and I'm wear'n milk bone underware!