View Full Version : Currency Question


wizcow2
09-15-2003, 07:52 PM
Hi

In my table I have a feild for 'price'
It is a 'number' feild 'single' set to 'currency'

When I enter the number $124.88 it stores it as 124.88356789562

This is causing errors when a tax calculation is applied.

How should I be doing this?

Tom

WayneRyan
09-15-2003, 08:45 PM
Wizcow,

In your table's design view, the field should be of type
Currency, not number.

Wayne