I have a VFP6.0 table with a numeric field (named say f1) that supports null values. If I make all records have f1 equal null and issue the following commands:

STORE .NULL. TO x
CALCULATE AVG(f1) TO x

I expected to see NULL as the result but instead VFP returns 0.000.

Is there anyway to have NULL returned when all values for the field are null?

TIA. Mike