Question 3 decimal places

Trugga

New member
Local time
Today, 07:03
Joined
Oct 2, 2011
Messages
3
Access 2010 W7(32)

I'm in the process of putting together a simple DB for our Quality Manager, this partcular part relates to Calibration Data.

I would like to store a set of measurements:
0.000
2.540
6.350
...
584.200

However, I cannot get them to display as I've typed them above.

In the table, I select Number, with properties of:
Field Size = Decimal
Precision = 7
Decimal Places = 3
Input mask = 0.###

Entering data directly into the table, say 19.050, I'm informed that the data isn't appropriate for the mask

If I enter 9.050 it resorts to 19.000

I'm obviously missing something - any pointers would be appreciated.

Lawrence
 
In the Table, Field Properties, Field Size put DOUBLE, (for this field).
 
The input mask controls what can be entered not the way it is displayed.
To always show three decimal places the Format property should be 0.000

Decimal is a Precision Scaled Integer. It is actually the most appropriate field type to used for your purposes (though Double will also work).

You just need to enter the properties correctly.
Scale and Decimal Places should be 3 for three decimal places on the Decimal fieldtype.
 
Absolutly fantastic - it works

Many thanks
Lawrence
 

Users who are viewing this thread

Back
Top Bottom