Rounding on data input

  • Thread starter Thread starter Preston Fiske
  • Start date Start date
P

Preston Fiske

I am having problems getting decimal data entered. All the
numbers get rounded. I am wondering if the file structure
is locked once data is there. Do I have to build a new
table and import the existing data?
 
Preston Fiske said:
I am having problems getting decimal data entered. All the
numbers get rounded. I am wondering if the file structure
is locked once data is there. Do I have to build a new
table and import the existing data?
Click to expand...

How did you set up the field? If you used Integer or Long Integer for the
size then you will get rounding because neither of those support fractional
values. To support fractional values you need to use either Single,
Double, or the Currency DataType.
 
I have tried to set up the field as decimal with a
currency format, 2 decimal places.
 
[email protected] said:
I have tried to set up the field as decimal with a
currency format, 2 decimal places.
Click to expand...

The format is irrelevant if you are using a size that doesn't support
fractional values. What is the Data Type and Field Size of your field?
 
Back
Top