currency fields

Ted Kirkendall
09-05-2000, 11:42 AM
I have fields in my database that are of the currency data type. Why are they stored w/ more than two trailing decimal points? It is messing up my totals. How can I force it to two places?
thanks ted

Birddog
09-05-2000, 01:17 PM
If you are using access, on the design screen change the property for decimal points from auto to just 2 and see if that clears up your problem.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum