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
|
|||
|
|||
% and numbers
I've got a column in a table that I want to make a percent value.
I enter 12.5 and it returns 12.000.00 !!!!!!!!!!!!!! so it's calculating it for me I get it. I just want the figure. So I make it a NUMBER, with 2 decimal places. I enter 12.5 and it returns 12 !!?? I change it to auto decimal places It returns 12 I change it to 1 decimal places., it returns 12. Please, what am I missing here? Jen |
#2
|
|||
|
|||
% and numbers
When you set a field in a table as Number, the default data type is Long
Integer, which cannot store any fractional part. Take a look at the "Field Size" property in the bottom left of the design interface. To store fractional parts, you need to use one of Single, Double or Decimal. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "JB" somehow@somewhere wrote in message ... I've got a column in a table that I want to make a percent value. I enter 12.5 and it returns 12.000.00 !!!!!!!!!!!!!! so it's calculating it for me I get it. I just want the figure. So I make it a NUMBER, with 2 decimal places. I enter 12.5 and it returns 12 !!?? I change it to auto decimal places It returns 12 I change it to 1 decimal places., it returns 12. Please, what am I missing here? Jen |
#3
|
|||
|
|||
% and numbers
wow that was quick.
That did it. Thank you ! Jen "Douglas J. Steele" wrote in message ... When you set a field in a table as Number, the default data type is Long Integer, which cannot store any fractional part. Take a look at the "Field Size" property in the bottom left of the design interface. To store fractional parts, you need to use one of Single, Double or Decimal. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "JB" somehow@somewhere wrote in message ... I've got a column in a table that I want to make a percent value. I enter 12.5 and it returns 12.000.00 !!!!!!!!!!!!!! so it's calculating it for me I get it. I just want the figure. So I make it a NUMBER, with 2 decimal places. I enter 12.5 and it returns 12 !!?? I change it to auto decimal places It returns 12 I change it to 1 decimal places., it returns 12. Please, what am I missing here? Jen |
Thread Tools | |
Display Modes | |
|
|