>>>>CALCULATE SUM(fieldname) FOR RECNO() < 0
>>>
>>>
>>>But would'nt this only look at new records? Existing records would be ignored.
>>
>>Another possible issue. CALCULATE() changes the record pointer. Depending on the buffering mode, this could commit a record that the developer is not ready to commit. You need to make sure that table buffering is set on.
>
>
>The original post said that he was using optimistic table buffering AND he wanted to only sum new records....
I missed that one. I guess that's not an issue then (note I said "possible" :))