If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Percent format problem
I have a table field I want to set up as a percentage. When I enter 70 in
it I get 700.00%. When I enter .7 in it, I get 100.00%. Am I misunderstanding how percentage fields work? I just want 70% in the field... Thanks; Amy |
#2
|
|||
|
|||
Percent format problem
It looks like your field might be long integer or integer. If you want to
store a percentage, then you should use a double, single, currency, or decimal field type. I expect entering 70 would give you 7000.00% and not 700.00%. The number 1 is 100%. If you want 70%, enter its value as .7. -- Duane Hookom MS Access MVP -- "Amy Blankenship" wrote in message ... I have a table field I want to set up as a percentage. When I enter 70 in it I get 700.00%. When I enter .7 in it, I get 100.00%. Am I misunderstanding how percentage fields work? I just want 70% in the field... Thanks; Amy |
#3
|
|||
|
|||
Percent format problem
Yes, I spotted that right after I posted. Changed it to a double and it
worked. Thanks; Amy "Duane Hookom" wrote in message ... It looks like your field might be long integer or integer. If you want to store a percentage, then you should use a double, single, currency, or decimal field type. I expect entering 70 would give you 7000.00% and not 700.00%. The number 1 is 100%. If you want 70%, enter its value as .7. -- Duane Hookom MS Access MVP -- "Amy Blankenship" wrote in message ... I have a table field I want to set up as a percentage. When I enter 70 in it I get 700.00%. When I enter .7 in it, I get 100.00%. Am I misunderstanding how percentage fields work? I just want 70% in the field... Thanks; Amy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cannot format parameter as percent on a report | Veli Izzet | General Discussion | 2 | August 12th, 2005 12:00 PM |
Format problem : "Text" & Number; Number -> Standard format. How? | BerHav | Setting Up & Running Reports | 0 | August 19th, 2004 06:31 PM |
Mail Merge Date Format Problem | Nick | Publisher | 2 | August 17th, 2004 04:55 PM |
Incoming Mail Format Problem | GK1963 | General Discussion | 1 | July 19th, 2004 08:54 PM |
Number format problem in CSV files | Mervyn Thomas | Worksheet Functions | 3 | January 14th, 2004 06:31 PM |