>Hi everybody,
>Is there a way to quickly summarize the values of a table into a cursor based on something, in this case the partno.
>
>The structure of table is Date D, Commodity C(30), Suppid C(10), Partno C(17), def_0199 I, def_0299 I, def_0399 I, def_0499 I, etc.
>
>Lets say that I want a summarization of four (4) partno's, I want to return the identical structure expect that it would contain only the summarized data for the four partno's.
>
>Thanks,
>Joseph Schaff

Do you want to summarize those four partno's into the new partno or summarize all records for each partno? What values do you want to put into Date D, Commodity C(30), Suppid C(10) fields in the summary records?