98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Formatting percentages
Formatting percentages
Resolved · Low Priority · Version 2002/XP
Mon 28 Apr 2008, 13:27Delegate Steven said...
Steven has attended:
Access Intermediate course
Formatting percentages
When formatting a field to show % how do you stop the figures from automatically rounding up. For example i would like to show 99.71% so i type 0.9971 and it automatically rounds up to 100%. The problem that i face is that all of the records in this field range between 99 and 100% and i need to show them exactly to 2 decimal places.
Wed 7 May 2008, 21:50
Edited on Wed 7 May 2008, 22:13Trainer Pete said...
RE: formatting percentages
Hi Steven, Thanks for the post, Try this in your table in design view:
Set the Field properties as follows:
Field Size : Decimal
Format : Percent (Or as per your own preference.)
Precision : 18 (Or as per your own preference.)
Scale : 4 (Has to be set in oder to display values after decimal seperator)
Decimal Places : 2 (Or as per your own preference.)
Hope that works, best regards Pete
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:DsumYou can create percentage values based on individual products / items by using a Dsum function (used with a grouped query) |
