>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...