Ok this is driving me nuts, I really hope someone can help. I have edited cell properties to number and double decimal places. However, if my number is 7.10 for instance I need it to stay as 7.10 and not be changed to 7.1
Ok this is driving me nuts, I really hope someone can help. I have edited cell properties to number and double decimal places. However, if my number is 7.10 for instance I need it to stay as 7.10 and not be changed to 7.1
You should tell Access you want Number, single, 2 decimal places.
there are several things you can do, if this is a currency field you can set the format either on the table or in a query to 'currency', decimal places are automatically considered to be 2
Otherwise on the table you can set the data type to DOUBLE and set the format to FIXED and the decimal places to 2
or in a query you can set a manual format like
format([NumberField], "#0.00")
but beware of doing this because the format function has an annoying habit of treating number fields like text fields.
Single with 2 places doesn't work. I can't see where in data type I can select DOUBLE
table design, if it's a calculated field and not a field from your table you can also set the properties in the query design window by right clicking on the column and selecting from the PROPERTIES option and set the format to fixed/2 decimals.
This works for me