Rounding on data input

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?
 
R

Rick Brandt

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.
 
P

prestonfiske

I have tried to set up the field as decimal with a
currency format, 2 decimal places.
 
R

Rick Brandt

[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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
Excel does not accept text format! 0
Creating a Chart on form from selected data in query. 0
Outlook 2016: recent change to add account. No browse for data file. 0
Stop Rounding in Forms 2
Possible to Combine reports to's to a single box? 0
How can the font and size of (all) citation numbers be altered? 1
Rounding difference in Access 2003 text exports 2

Top