Format a table field

[Amateur]

I have an append query where all data is shown correct.
If I append this query to a table, one field is showing instead of 1.86 -
2.00. I've tried all possible configurations: I declared it as a number
field, decimals 2, format #,##0.00;(#,##0.00)[Red].
But it always shows 2.00 .
Can soemone help?
Klaus

 

[Jerry Whittle]

Format is how data is displayed - not how it's stored.

Check the data type. I be that it's a Byte, Integer, or more likely, Long
Integer. An integer data type doesn't have decimals. Therefore it's being
rounded.

Change the data type to a Double. Problem solved, I bet.

 

[John W. Vinson]

I have an append query where all data is shown correct.
If I append this query to a table, one field is showing instead of 1.86 -
2.00. I've tried all possible configurations: I declared it as a number
field, decimals 2, format #,##0.00;(#,##0.00)[Red].
But it always shows 2.00 .
Can soemone help?
Klaus

What is the datatype of the field? Open the table in design view, and select
the field; in the lower left of the screen it will indicate what kind of
number it is.

My guess is that it is the default size for a number field - Long Integer. An
Integer is by definition a whole number.

Change it to Single or Double or Decimal, or change the datatype from Number
to Currency; I'd do the latter if the field refers to money.