Round to 2 decimal places (1 Viewer)

[accessfever]

Hi, I have about ten append queries to group various financial data to one main table. I have used the round function (iff (Round(Nz([FIN_data]),2)) in the queries to round the original data into 2 decimal places but there is still one or two lines exceeding 2 decimal places. What is the better approach to have only 2 decimal places for all append data? Any help will be appreciated.

 

[jdraw]

You could always use Currency or Double.

or see this

 

[Simon_MT]

Or Int(A x 100)/100

Simon

 

[accessfever]

Thanks all for your adivses. I used both ways and now my data is down to 2 decimal places.

 

[pr2-eugin]

Or you can use FormatCurrency.

? FormatCurrency(12.568788, 2)
£12.57