Percentage Field - How To Build a Customer Database, Enter Data, Sort, Filter, and Create Forms in Microsoft Access


	Back to Access Beginner 1 Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Percentage Field

Mohammed Aslam Khan

2 years ago

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 Khan OP @Reply 2 years ago

	Mohammed Aslam Khan OP @Reply 2 years ago

	Mohammed Aslam Khan OP @Reply 2 years ago

	Mohammed Aslam Khan OP @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 Khan OP @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 Khan OP @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 Khan OP @Reply 2 years ago
i deleted the field and entered the second time but the result is the same, no update.

	Mohammed Aslam Khan OP @Reply 2 years ago

	Mohammed Aslam Khan OP @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 ;) Spoiler Your Data Type on the field is Long Integer instead of Double

	Mohammed Aslam Khan OP @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 Khan OP @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 Khan OP @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 Khan OP @Reply 2 years ago
very important lesson learned. Thank you both Adam and Sami for your help.

	Richard Rost @Reply 2 years ago
My guys are the best. 😁

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 1 Lessons.

Next Unseen

New Feature: Comment Live View