'Temperature' field saving w/ two numbers after decimal

[Guest]

Hello,

I have a 'temperature field I am saving as a 'Decimal - Fixed' with a '4'
Precision and a '1' Scale and an 'Input Mask' of '999.9'. It keeps saving
values w/ a trailing zero. For example, '99.8' saves as '99.80'. I've tried
various combinations of the above settings, but that trailing zero is always
thrown in. I know that technically, '99.8' is the 'same' value as '99.80',
but the Access data is being read by another statistical program that will
expect '99.8'. How can I force this value to be '99.8'?

Thanks.

 

[John Vinson]

Hello,

I have a 'temperature field I am saving as a 'Decimal - Fixed' with a '4'
Precision and a '1' Scale and an 'Input Mask' of '999.9'. It keeps saving
values w/ a trailing zero. For example, '99.8' saves as '99.80'. I've tried
various combinations of the above settings, but that trailing zero is always
thrown in. I know that technically, '99.8' is the 'same' value as '99.80',
but the Access data is being read by another statistical program that will
expect '99.8'. How can I force this value to be '99.8'?

Thanks.

Set its Format property to #.0

You'll also need to use the Format$() function in a calculated field
when you go to export the data - the export routine ignores input
masks and formats.

John W. Vinson[MVP]

 

[Guest]

Thank you, John!

Set its Format property to #.0

You'll also need to use the Format$() function in a calculated field
when you go to export the data - the export routine ignores input
masks and formats.

John W. Vinson[MVP]