access/courses - How do I format numbers in tables to hold two decimal places?

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

Resolved · Low Priority · Version Standard

How do I format numbers in tables to hold two decimal places?

Christine has attended:
Access Introduction course
Access Intermediate course

by - delegate Christine [1 post] (2007 Mar 21 Wed, 10:04) Reply

I am trying to use a database that someone else has created and need to format one of the number fields to two decimal places.

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: How do I format numbers in tables to hold two decimal places

by - trainer Rich platinum contributer [744 posts] (2007 Mar 21 Wed, 11:32) Reply

Hi Christine,

Switch to design view, and click on the Data Type cell of the field you want to add decimal places to.

Look at the Field Properties below. Under the General tab, you can adjust the Decimal Places value (third property down). Type 2, or choose 2 from the drop-down box.

If this answers your question, please mark this question as resolved.

Hope you enjoy your Access Intermediate Course tomorrow.

Regards, Rich

· Why Do I Need To Use Access?
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Why go on a Microsoft Access Training Course?
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Tips for designing databases in Microsoft Access

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips