SELECT SUM(foo) ; FROM MyFooTable ; WHERE ; INTO ARRAY laSumFoo
IF _TALLY > 0 WAIT WINDOW STR(laSumFoo[1]) ENDIF
--Paul
>The documentation seems to imply that the above is possible... Im trying to get a total of a (filtered) field.. How can I dump the above into a variable