Subtraction with decimals

[UT227]

I'm trying to do some simple calculations. In order to use decimals, I used DOUBLE instead of LONG INTEGER on my table. When I tried to subtract, I got some very strange answer (scientific?) Adding worked with no problems at all. Subtracting seems to be a problem. Any ideas?

[ranman256]

If you don't need long decimals, use Currency. It'sIt's only has 4 decimals.
and if its not money, you can turn off the dollar sign.

[UT227]

Thanks. I didn't think of that. How do I turn off the dollar sign?

[aytee111]

The scientific expressions often happen when the width of the field is not wide enough. Also when there are data problems. I wouldn't use Currency unless it is actually currency and never on a table, only in forms/reports. It is just a way of showing the data to you, it has nothing to do with what is really stored.

Make a query that displays the fields you are using in the calculations, then look to see which ones are causing the problem and visually make a determination as to why it is happening. Don't use formatting on any of the fields, display them as they are stored on the table.