Solved: Field Size Properties

[ciavala]

I have numbers in my table that I want to show 2 decimal points, so I chose to use Single as my property type. When I use this table in a Query, 7 decimal points show up and I only want 2 to show. I set the properties to 2 decimals, but it still shows 7 decimals. :help:help

[MikeWolfeJr]

I have numbers in my table that I want to show 2 decimal points, so I chose to use Single as my property type. When I use this table in a Query, 7 decimal points show up and I only want 2 to show. I set the properties to 2 decimals, but it still shows 7 decimals. :help:help
Ciavala...

You must also set the Format for the number in the properties for the field (either in the table or the query). Any Format other than General should make your number of decimals work.

Specifying this in the table will carry-over to (be inherited by) any queries, forms, reports, etc. you create with that field.

Remember, these formatting options are only for output purposes. The numbers are actually stored in the database according to the datatype you specified. So, even if you choose a 2-decimal fixed format for, say the number 3.14159, the database still maintains the entire precision of the number. It will be output, however, as 3.14. It is also very important to note that calculations will use the entire precision of the number unless you use functions to reduce the precision (e.g., round).

Hope that helps, and explains a little bit how numbers are handled. I know I went round and round (no pun intended) with these exact issues when I started working with Access and Excel... especially with calculations not "adding up" on reports, etc.

[ciavala]

Thanks for the info Mike, it was very educational. I set the format to fixed and it is working just fine now.



Thanks

Ciavala