Hello,

When I use a "Calculate Sum(Invtotal) to X" command, Foxpro makes X a currency field. I am trying to replace a field in a table (defined as N(9,2) and always get 0 in the receiving field. I know why I have zeros, but I don't know HOW to change the type field in X. Anybody have any ideas?

Any help would be appreciated.

Barry