Removing Trailing Numbers

[swagger18]

Apoligises if this has been asked already.

I have coded a formulae on Access that i have imported from Excel but made tweaks where necessary.

The formulae is correct but i have about 27 trailing numbers e.g. 7.7xxxxxxxxxxxxxxxxxxxxxxx how can i get rid of these numbers.

Cheers in advance

[NoellaG]

Hi,

you can use the Round function if you really want to limit the number to the given decimals: Round(Number,Number of digitals)

or the Format function if you want to keep all decimals but just show it with less decimals: Format(Number, "Format expression")

gr
NG

[swagger18]

Cheers geeze i will look into them this afternoon.

[swagger18]

Cheers man for your input but i changed the properties of the field in SQL to decimal(2, 1) and it seemed to work.

Your Round expression worked for me to solve another problem tho so thank you.