Ron: That works perfectly fine in both old DOS and Windows. The double value is evaluated correctly. The problem is turning that into a "currency", which we have to have in this situation. If the decimal is something like .785, windows puts it at .79, DOS puts it at .78.
We got around it by forcing windows to act like DOS does, using the BRnd feature in our computed column: (Brnd(S_Qty * S_Unit, 13, .01)). We would rather than it rounds up like windows does because that's more accurate, but that would cause all the old records to be off by a penny if they were edited. Karen > S_AmtD is Double > S_AmtD = (S_Qty * S_Unit) > S_Amt = S_AmtD > Maybe the above will show something. > > Ron Rose >
