Hi Naomi

Thx for that, and there was me trying to be clever and do it in SQL.

That'll teach me LOL

.



>>Can someone please remind me how to get VFP to look at uncommitted changes on an optimistically buffered table.
>>
>>I want to sum a column in the table & am trying to use SQL wherever I can, but my command is not looking at the buffered data.
>>
>>help!
>
>Robin,
>
>Check WITH BUFFERING option in Select-SQL Help (new option in VFP9). However, my tests indicated that using this option may slow down queries, so may be you better off with DBASE syntax using SUM command rather than Select-SQL.