446,327 Members | 1,791 Online
+ 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
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" 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" 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 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 becomes4.00. I tried fiddling with the properties, setting the numbers ofdecimals, etc. to no avail.Worse yet, when exporting the data, it retains the rounded figure asthe 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 acceptany 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" 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 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 becomes4.00. I tried fiddling with the properties, setting the numbers ofdecimals, etc. to no avail.Worse yet, when exporting the data, it retains the rounded figure asthe 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 acceptany 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.