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 10 months ago
Please provide more information
Mohammed Aslam KhanOP 10 months ago
Mohammed Aslam KhanOP 10 months ago
Mohammed Aslam KhanOP 10 months ago
Mohammed Aslam KhanOP 10 months 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 10 months ago
What data are you entering into the field?
Mohammed Aslam KhanOP 10 months ago
numbers 20, 30 and 50 for the 3 records
Sami Shamma 10 months ago
A percentage is a number between 0 and 1.
So, 20% is 0.2.
30% is 0.3.
Mohammed Aslam KhanOP 10 months 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 10 months ago
Change the name of the field and try it again
Mohammed Aslam KhanOP 10 months ago
i deleted the field and entered the second time but the result is the same, no update.
Mohammed Aslam KhanOP 10 months ago
Mohammed Aslam KhanOP 10 months ago
i tried 0.2 and 20, both, but the moment i leave the field it turns back to 0.00%
Adam Schwanz 10 months 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 10 months ago
when i entered 51 it shows 100.00%
Adam Schwanz 10 months ago
I put the answer there if your just looking for a quick answer. Otherwise remember how numbers work, especially integers
Mohammed Aslam KhanOP 10 months 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 10 months 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 10 months ago
Thank you Adam.
I missed that.
Mohammed Aslam KhanOP 10 months 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.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
