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
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