access database course - Formatting numbers

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

Resolved · Low Priority · Version Standard

Formatting numbers

Sabine has attended:
Access Intermediate course

by - delegate Sabine [7 posts] (2007 Oct 30 Tue, 13:37) Reply

I am having trouble formatting numbers. WHen i am in design value in tables, and i choose percentage as the format, it doesn't format properly. For example if i insert 59%, it comes out as 100%. If i insert 0.59 it comes out as 0. Please help. thanks

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
Full Schedule: See all 48 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: formatting numbers

by - trainer Katie gold contributer [214 posts] (2007 Nov 1 Thu, 16:39) Reply

Hi Sabine,

Thanks for your question.

In the Table Design View:
1) set field as Number
2) in field properties, set field size as either SINGLE/DOUBLE
3) in field properties, set format as PERCENT

Hope this helps.

Regards,

Katie

· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· How Reorganising Your Data Can Take Your Business to the Next Level
· Get More Out of MS Access Courses
· Why a Microsoft Access Course Could Change the Way You Do Business
· The Benefits of Certified Microsoft Training in Access

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips