>Jim and Larry,
>
>You are right (well almost ever :) ), I have in the form two modes (one for New and other for Modify), in the New mode I'm doing SUM ... TO but in the Modify mode I'm doing a SELECT SQL !!! (Stupid of me.....)
>
>I assume than CALCULATE SUM.. works like the SUM.. TO. Must I choose one of these? Is any better?
>
>Thanks for your reply.. I was going mad with this.
Pablo,
CALCULATE SUM is the same as SUM TO. CALCULATE allows you to include more than one calculation on a single command line, that is you can CALCULATE SUM and AVG at the same time while using the AVERAGE and/or SUM commands can only do one of them.