Hi, I have a Percentage field defined as number and format selected as percent and decimal selected as 0. However when i enter information it does not update and remains as 0%. Please advise
Sami Shamma
@Reply 2 years ago
Please provide more information
Mohammed Aslam KhanOP
@Reply 2 years ago
Mohammed Aslam KhanOP
@Reply 2 years ago
Mohammed Aslam KhanOP
@Reply 2 years ago
Mohammed Aslam KhanOP
@Reply 2 years ago
I tried entering information in both, Table as well as Form, but the result is the same 0%. does not update the record.
Sami Shamma
@Reply 2 years ago
What data are you entering into the field?
Mohammed Aslam KhanOP
@Reply 2 years ago
numbers 20, 30 and 50 for the 3 records
Sami Shamma
@Reply 2 years ago
A percentage is a number between 0 and 1.
So, 20% is 0.2.
30% is 0.3.
Mohammed Aslam KhanOP
@Reply 2 years ago
yes i tried entering as 0.2, 0.3 and 0.5 but the moment i click on tab to move to the next field, it becomes 0%
Sami Shamma
@Reply 2 years ago
Change the name of the field and try it again
Mohammed Aslam KhanOP
@Reply 2 years ago
i deleted the field and entered the second time but the result is the same, no update.
Mohammed Aslam KhanOP
@Reply 2 years ago
Mohammed Aslam KhanOP
@Reply 2 years ago
i tried 0.2 and 20, both, but the moment i leave the field it turns back to 0.00%
Adam Schwanz
@Reply 2 years ago
I'll give you a hint, if you put 51 in there see what happens ;)
SpoilerYour Data Type on the field is Long Integer instead of Double
Mohammed Aslam KhanOP
@Reply 2 years ago
when i entered 51 it shows 100.00%
Adam Schwanz
@Reply 2 years ago
I put the answer there if your just looking for a quick answer. Otherwise remember how numbers work, especially integers
Mohammed Aslam KhanOP
@Reply 2 years ago
i enter any number <=50 it goes back to 0.00% and if i type any number >50 it shows 100.00%
Mohammed Aslam KhanOP
@Reply 2 years ago
Thank you very much Adam, the problem is resolved. Yes the field size was Long Integer. I changed it to Double and now it works fine. Thanks again
Sami Shamma
@Reply 2 years ago
Thank you Adam.
I missed that.
Mohammed Aslam KhanOP
@Reply 2 years ago
very important lesson learned. Thank you both Adam and Sami for your help.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.
