By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

vexing decimal problems

P: n/a
There is problem a veyr simple solution to this, but I am stumped!

My table keeps "rounding" up or down decimal numbers to whole numbers.
In other words, if I enter a value of "3.75" into a field, it becomes
4.00. I tried fiddling with the properties, setting the numbers of
decimals, etc. to no avail.

Worse yet, when exporting the data, it retains the rounded figure as
the value for the field. Yipes.

I am hearing from other people that Access will not accept the value
..5 at all, which I think makes no sense. But I can't get it to accept
any decimal at all right now without this idiotic rounding.

Gwin
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Change the datatype from Long or Integer to Single or Double. Long and
Integer only deal with whole numbers.

Mike Storr
www.veraccess.com
"Gwin" <do*********@verizon.net> wrote in message
news:q7********************************@4ax.com...
There is problem a veyr simple solution to this, but I am stumped!

My table keeps "rounding" up or down decimal numbers to whole numbers.
In other words, if I enter a value of "3.75" into a field, it becomes
4.00. I tried fiddling with the properties, setting the numbers of
decimals, etc. to no avail.

Worse yet, when exporting the data, it retains the rounded figure as
the value for the field. Yipes.

I am hearing from other people that Access will not accept the value
.5 at all, which I think makes no sense. But I can't get it to accept
any decimal at all right now without this idiotic rounding.

Gwin

Nov 12 '05 #2

P: n/a
Open your table in design view.
Select the problem field.
In the lower pane, set the Field Size to "Double".

The integer types can record only whole numbers.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gwin" <do*********@verizon.net> wrote in message
news:q7********************************@4ax.com...
There is problem a veyr simple solution to this, but I am stumped!

My table keeps "rounding" up or down decimal numbers to whole numbers.
In other words, if I enter a value of "3.75" into a field, it becomes
4.00. I tried fiddling with the properties, setting the numbers of
decimals, etc. to no avail.

Worse yet, when exporting the data, it retains the rounded figure as
the value for the field. Yipes.

I am hearing from other people that Access will not accept the value
.5 at all, which I think makes no sense. But I can't get it to accept
any decimal at all right now without this idiotic rounding.

Gwin

Nov 12 '05 #3

P: n/a
Gwin wrote:
There is problem a veyr simple solution to this, but I am stumped!

My table keeps "rounding" up or down decimal numbers to whole numbers.
In other words, if I enter a value of "3.75" into a field, it becomes
4.00. I tried fiddling with the properties, setting the numbers of
decimals, etc. to no avail.

Worse yet, when exporting the data, it retains the rounded figure as
the value for the field. Yipes.

I am hearing from other people that Access will not accept the value
.5 at all, which I think makes no sense. But I can't get it to accept
any decimal at all right now without this idiotic rounding.

Gwin


Exactly what is the datatype of the field? View the table in design
mode, and note both the Type (above) and Length (below) settings.

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #4

P: n/a
Hi:

I had exactly the same problem, and followed the solution given in the last message.
Numeric appears to default to the wrong characteristic. I think most people would not want
an integer!

Regards

John Baker

Gwin <do*********@verizon.net> wrote:
There is problem a veyr simple solution to this, but I am stumped!

My table keeps "rounding" up or down decimal numbers to whole numbers.
In other words, if I enter a value of "3.75" into a field, it becomes
4.00. I tried fiddling with the properties, setting the numbers of
decimals, etc. to no avail.

Worse yet, when exporting the data, it retains the rounded figure as
the value for the field. Yipes.

I am hearing from other people that Access will not accept the value
.5 at all, which I think makes no sense. But I can't get it to accept
any decimal at all right now without this idiotic rounding.

Gwin


Nov 12 '05 #5

P: n/a
The default number type (as with default string length, Indexed field names
etc.) can be changed in Tools > Options
"John Baker" <Ba******@Verizon.net> wrote in message
news:d3********************************@4ax.com...
Hi:

I had exactly the same problem, and followed the solution given in the last message. Numeric appears to default to the wrong characteristic. I think most people would not want an integer!

Regards

John Baker

Gwin <do*********@verizon.net> wrote:
There is problem a veyr simple solution to this, but I am stumped!

My table keeps "rounding" up or down decimal numbers to whole numbers.
In other words, if I enter a value of "3.75" into a field, it becomes
4.00. I tried fiddling with the properties, setting the numbers of
decimals, etc. to no avail.

Worse yet, when exporting the data, it retains the rounded figure as
the value for the field. Yipes.

I am hearing from other people that Access will not accept the value
.5 at all, which I think makes no sense. But I can't get it to accept
any decimal at all right now without this idiotic rounding.

Gwin

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.