Best Data Type of fileds for Numbers?

[Fekri]

Hi,

I have headache problem in my tables data:

I need just 2 decimal on all numbers in the fields just when needed.
for example If the number has no any decimal should not show any decimal place in filed data and when I entered the "25.0245689" just show "25.02"
I used fixed or round or many thing in record source of text boxes but in calculation of some query the rules will changed.

Thanks for any Idea which type of format for Number is best for my tables?

Thanks
Ali

 

[Ed2020]

I think you need to use the following:

Data Type: Numeric
Field Size: Decimal
Scale: 2
Decimal Places: 2

Scale determines the number of digits after the decimal that are stored.

Decimal Places determines the number of digits after the decimal place that are displayed.

Setting Decimal Places without Scale may be what is causing the symptoms you describe.

Ed Metcalfe.

Please do not feed the trolls.....