Decimal Places

[aziz rasul]

I have values (using a make-table query) in an Currency field like £123.45.

Using an update query, I want to make these values become £123. What function, or otherwise, can I use to get this?

I have used a combination of the Round and CInt functions to do this but all I get is £123.00 not £123. I know I can change the DecimalPlaces table property to 0 to get what I want, but I am running code to do all this, hence I need an update query that will resolve the issue if possible.

 

[*Pete*]

You will need to change the field in the table to 0 decimal places or it will always display the .00

 

[aziz rasul]

Is there a way of changing this using VBA?