 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / March 2007entering percentages in table
I have been away from MS Access for quite a few years and am starting over on my skills. I have created a field in a table that is for whole number percentages from 1 to 100, but when I enter any whole number, two zeros are automatically added, so 70% becomes 7000%. It's probably obvious to most of you, so perhaps someone could jog these frozen brain cells. In Access the percent data type is expected to be a value between 0 and 1. You'll need to either divide your field value by 100 or change how the value is being stored. Carl Rapson >I have been away from MS Access for quite a few years and am starting over >on [quoted text clipped - 5 lines] > It's probably obvious to most of you, so perhaps someone could jog these > frozen brain cells. On Mar 29, 3:35 pm, "Carl Rapson" <mr.mxyzp...@newsgroups.nospam> wrote: > In Access the percent data type is expected to be a value between 0 and 1. Misstatement, methinks. There is no percent data type I know of. Jamie. -- Right, thanks. I was thinking of the Format of the control on the form. Carl Rapson > On Mar 29, 3:35 pm, "Carl Rapson" <mr.mxyzp...@newsgroups.nospam> > wrote: [quoted text clipped - 6 lines] > > -- Percent is a fraction - 50% equals half or 0.5 but is displayed as a whole number. So to enter 70% your field must be able to handle fractions and you would enter .7 for display of 70&.  SignatureKARL DEWEY Build a little - Test a little > I have been away from MS Access for quite a few years and am starting over on > my skills. I have created a field in a table that is for whole number [quoted text clipped - 3 lines] > It's probably obvious to most of you, so perhaps someone could jog these > frozen brain cells. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.