Currency Calculations

[TimTDP]

In Access 2000, I have a field called "Price" Its data type is currency, format = fixed, decimal places = 2

In query calculations, I tend to loose the fixed number of decimal places. e.g

If price = 12 and quantity = 15, 12 * 15 = 180
but
If price = 32.49 and quantity = 191.1, 32.49 * 191.1 = 6208.839

How can I ensure that the results remains fixed, 2 decimal places? I need to do this to prevent round problems.
I have tried the function "Round", but with limited success.

 

[rjoubert]

CCur([price]*[quantity])

 

[TimTDP]

Thanks
This inserts the default currency symbol in the result.
How can I prevent this?

 

[rjoubert]

You can use the format function instead...

Format([price]*[quantity], "#.##")