Problems with rounding up currency

[dafyddg]

Hi,

I've written an SQL query thats designed to increase all the values in a field by a specified percentage. This is the SET part of the query

SET Rates.[Unit Cost] = Rates.[Unit Cost] * " & actualrate

Unit Cost field is set to Curreny with 2 decimal places and actual rate is a number such as 1.01 for 1% increase.

The problem i'm having is that the figures aren't being rounded up to two decimal places. They are stored with 4 even though at first they only display 3. Is there something i can do about this or will i need to write code to deal with this situation.

 

[BobJacksonNCI]

Hi,

The round function should do it:

SET Round(Rates.[Unit Cost],2) = Rates.[Unit Cost] * " & actualrate



HTH,
Bob

 

[PaulBricker]

Make sure the Format Property for the field in your query is set to Currency. If you right click on the field and open Properties, you will see the format property. Set it to Currency. If for some reason that doesn't work, you can try wrapping your expression in the
CCur(Rates.[Unit Cost] * " & actualrate
) expression.

Paul

 

[dafyddg]

Thanks for the replies guys, Bob, that Round function worked a treat. Thanks