Hi Garrett,
Is true for floating point, but not for fixed point. Read my Message #
798979.
Fixed point is automatical round values to the length of the decimal portion.
On fixed numeric value, sum within data domain is exact.
On VFP, this is true for currency, but not for N(X,Y).
If you exec sums on MSQL and VFP of identical fixed point data, you can obtain not equal result.
I have inasmuch as this is not felt like a problem for the community, therefore the Microsoft will not make null in order to resolve it.
Now i have only two possibility:
or i make to make the computations to MSQL;
or i write all the ruotines of calculation in C (to this point i abandon VFP).
Fabio