Jeff,
Add a report variable, lets call it "total1". In "value to store", put "total1" (I know, it seems weird, no quote marks of course), Calculate Nothing, initial value of zero.
In the group "On Entry Expression" (double click on group heading bar in designer), put:
_vfp.setvar("total1",total1 + field1)
Now you can use total1 at the end of the report...
HTH
>Hello,
>
>Within a report, I am trying to sum field1 based on when field2 changes.
>
>Example:
>
>Field1 Field2
>1 222
>1 222
>1 222
>12 111
>12 111
>12 111
>6 444
>6 444
>---
>19 Is the Quantity I am looking for. The sum option seems to sum every column. Any help would be appreciated.
>
>Jeff
Steve Gibson