Go Back   Access World Forums > Microsoft Access Discussion > Tables

Thread Tools Rate Thread Display Modes
Old 09-26-2014, 08:08 PM   #1
Newly Registered User
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Percentages %

Could I have a suggestion as to how to handle percentages

Example; I would like add a value of 1.23%

Should I enter this value into a text field or to a Number Field

In the number field a entry of 1.23 = 123.00%

In the text field a entry of 1.23% = 1.23%

If possible I would like to use the number field as I will be able to do further calculations

Your suggestions will be appreciated

Thank you

Attached Files
File Type: mdb Calculation.mdb (132.0 KB, 48 views)

access2010 is offline   Reply With Quote
Old 09-26-2014, 10:43 PM   #2
Super Moderator
MarkK's Avatar
Join Date: Mar 2004
Location: Vancouver BC
Posts: 7,761
Thanks: 10
Thanked 1,289 Times in 1,227 Posts
MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all
Percent, which is per cent, where cent is like century, or 100, so per 100, or /100.

So 1% is 1/100, or 0.01. 1.23% is 0.0123.

I think that is all you need to know. 100% = 1.

I would store a percentage as a number. Double is usually too much precision for what I do, so usually a single would be plenty.

Hope that helps,
formerly known as lagbolt | Windows 10 | Access 2010 | Visual Studio 2013 | "Institutions have a vested interest in perpetuating the problems to which they are the solution." - Clay Shirky
MarkK is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentages AuroX7 Queries 2 04-09-2006 09:07 AM
Fun with percentages Spruk_77 General 2 12-01-2004 09:34 AM
Percentages dadrew Forms 8 09-29-2004 04:07 AM
Percentages User Name Reports 1 06-12-2003 11:56 AM
Percentages Phillip Thomas Tables 1 05-09-2003 10:27 AM

All times are GMT -8. The time now is 06:43 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World