>Thanks for the reply J.C.
>
>I saw the VFP documentation that says that it ignores NULL values. If it does, then why is it that x is not NULL? As you can see from my example code, I initalize x to NULL first then call the CALCULATE command.
>
If you calculate an AVG() on a field in a table with no records, you get 0.00 as the result. As far as the CALCULATE command is concerned, your table has no records.
Steve Gibson