I have a view that has a column I want summed.(optimistic table buffering)

I can use the CALCULATE SUM(.... command on it ok but I am trying to avoid its use because it moves the record pointer causing problems in a grid on my form.

If I do a SELECT SUM(..... on the view I get the wrong result because it does not include uncomitted records. (I do not want to commit the records because I have a cancel button the uses TABLEREVERT)

Is there a way of doing a SELECT from a view that does not insist on using only committed records.