|
|
||||||
|
#1
08-26-08, 04:38 PM
|
|
|
|
|
I have set up a field, data type number, format= percent, but when I enter
the number 5, it comes up as 500% in the field on the table? if I try 0.05 = nothing shows.. what do I need to do? Haven't used Access for about 6 years.. |
|
|
|
#2
08-26-08, 05:06 PM
|
|
|
|
|
"Help Visio!" <HelpVisio> wrote in message
news:6d07 >I have set up a field, data type number, format= percent, but when I enter > the number 5, it comes up as 500% in the field on the table? if I try > 0.05 = > nothing shows.. what do I need to do? Haven't used Access for about 6 > years.. I'm stumped to. Supposedly, the percent format allows you to enter a number from 0 to 1 and the number is then multiplied by 100 and a % sign is stuck on the end. What appears to be happening is that the number is rounded BEFORE multiplying and the the remainder is eliminated or rounded up. .49 goes to 0 and .5 goes to 1. John... |
|
#3
08-26-08, 05:12 PM
|
|
|
|
|
"John... Visio MVP" <lancucki> wrote in message
news:8784 > "Help Visio!" <HelpVisio> wrote in message > news:6d07 >> I'm stumped to. > > Supposedly, the percent format allows you to enter a number from 0 to 1 > and the number is then multiplied by 100 and a % sign is stuck on the end. > > What appears to be happening is that the number is rounded BEFORE > multiplying and the the remainder is eliminated or rounded up. .49 goes to > 0 and .5 goes to 1. > > John... Okay, I changed the value from a Long Int to a Single and now it works. I still find that behaviour wierd. John... |
|
#4
08-26-08, 05:27 PM
|
|
|
|
|
Well, since an integer field cannot contain any number but a whole number (no
decimal portion) and percentages are fractional (they have a decimal) there is no way to store percentages in an integer field. Format changes how the value is displayed and has nothing to do with how the information is stored. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County John... Visio MVP wrote: [..] |
|
#5
08-26-08, 06:36 PM
|
|
|
|
|
On Tue, 26 Aug 2008 08:38:00 -0700, Help Visio!
<HelpVisio> wrote: >I have set up a field, data type number, format= percent, but when I enter >the number 5, it comes up as 500% in the field on the table? if I try 0.05 = >nothing shows.. what do I need to do? Haven't used Access for about 6 years.. My guess is that you used the default Number datatype, which is Long Integer. An Integer is by definition a whole number. Change it to Single or Double and you'll be able to enter either 0.05 or 5% (though entering 5 will correctly give you 500%). |
|
#6
08-26-08, 08:12 PM
|
|
|
|
|
"John Spencer" <spencer> wrote in message
news:4104 > Well, since an integer field cannot contain any number but a whole number > (no decimal portion) and percentages are fractional (they have a decimal) > there is no way to store percentages in an integer field. > > Format changes how the value is displayed and has nothing to do with how > the information is stored. >> John Spencer > Access MVP 2002-2005, 2007-2008 Thanks John S & John V. Put that way, it does make sense. For some reason I was equating Single with Int. Too many langauges, too many data types. John... |
|
|
| Similar Threads | |
| Format number field to show Percent How do I format a field so whenever a number is enter, the field automatically make that entry a Percent. I tried formattting the number to Percent but when I entered for... |
|
| Number Format and percent Dear all, 1. I am new to access program. I need to have 0.67 in a column in a table but when I put this into the column then it returns me 1. Is there a way to have it... |
|
| troubles with number field with percent format! Hi Everybody, I have troubles with field formated as percent. Working with TAB, when selecting that rov where should be number in percentage and when typing e.g 0.2 (without... |
|
| Format number (percent) in textbox Hello, I've got a textbox and i do want to set its format to 'Percent', in that way the user will simply type the number (eg: 10 for 10%). But my problem is the number... |
|
| Format number as percent Hi I have a field Yield coming from a dataset, type decimal. If I print the field, it shows the correct result (to 8 decimal places). However, I need to format the figure... |
|
|
All times are GMT. The time now is 06:08 PM. | Privacy Policy
|
How do I input number in Access data type=number; format=percent