Formatting percentages

The UK's most regular instructor-led training courses.
Training information: microsoft+access+course · Access course microsoft training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2002/XP

Steven has attended:
Access Intermediate course

by - delegate Steven [2 posts] (2008 Apr 28 Mon, 13:27) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	4	book now	£224	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	7	book now	£203	£230
2003	2008 Nov 5 Wed	Southwark	7	book now	£190	£224
2003	2008 Nov 21 Fri	Bloomsbury	7	book now	£110	£224
Full Schedule: See all 53 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: formatting percentages

by - trainer Pete platinum contributer [799 posts] (2008 May 7 Wed, 21:50) Edited on 2008 May 7 Wed, 22:13 Reply

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