Jeff:

Put the result into an array.

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

Rainbows, teddy bears, and lollipops unveiled.