Microsoft Access - Percent Field Not Storing Values Other Than 100%

Hello Experts,

I have a Microsoft Access database where the user is required to enter the yield into a field, ranging from 0% to 100% for the record.

The field has been setup as 'percent' data type, but for some reason, it always rounds it to 100% and stores 100% in the table.  Even if I do it as a 'general number', it will always round to 1.

Any thoughts as to why?  This may be simple, but I'm stumped on this one.

Thanks,

Diana
diana_gAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
Open the table in design view.  The field should be defined as Number but the specific type should be single and if you want only two decimal places displayed, set that now.  Sounds like yours is defined as Number/Integer.

Another option is Currency with a format of percent.  I like the Currency data type since it avoids many of the problems you run into with single and double and works fine as long as 4 decimal digits are sufficient.
2

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
Sounds like the field data type is Integer or Long Integer.

Set it to Single or Double, then see what happens...
0
clarkscottCommented:
Post your db here and we can look at it.
Scott C
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

diana_gAuthor Commented:
Thank you @boag2000.  Changing the field data type to Single worked!
0
PatHartmanCommented:
I feel like I'm invisible.
0
Jeffrey CoachmanMIS LiasonCommented:
@PatHartman
...I see your point...

In this case, (as you can see by short the time between our posts), I was in the process of posting, but you were a few moments ahead of me.  Thus I did not know at that time that you had replied.

Many times the OP will get many email notifications for the multiple Expert's replies.
Seeing many notifs for the same question, they will sometimes delete all of them except the most recent.  Then just look only at that post.

In cases like this, the rules of the site state that the first correct answer be accepted.
In this case that would be your post.

If you believe the accepted answer was incorrectly assigned, you can ask the OP to click the request "attention link", and ask that the accepted post be changed...

;-)

JeffCoachman
0
Jeffrey CoachmanMIS LiasonCommented:
@diana_g
See my post above...

I seems like Pat actually had the correct answer a few moments befor me.

The rules of this site state that you should accept the "first" correct answer.
in this case his was Pats reply:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28251962.html#a39528731

Please click the request attention link and ask the the accepted post be changed to Pat's post...

;-)

JeffCoachman
0
diana_gAuthor Commented:
Hello Experts,

@PatHartman, I did see @boag2000's post first, but you are correct.  My sincerest apologies and thank you for your help.

I have asked the Moderator to re-assign the accepted post.

Thank you,

@diana_g
0
PatHartmanCommented:
Thanks:)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.