fomatting prices

[Jill]

I have to format prices for my company. they go 2 ways. One way, they are
marked up by either 5 or 10 percent. If I update them as [price]*1.1 (or
1.05) the results may be something like 148.445, 193.6, or 66.

The other way is not a markup, but a markdown. Like a 20% discount. I do an
update query using [price]*.8, but again, I get the unrounded answers and
missing "cents".

Is there a way to make them come out with 2 decimal points? Like 148.44 (or
148.45), 193.60, and 66.00. An expression or setting that can be used?

I am using Access 2007.

 

[Beetle]

Typecast the calculated fields as currency using the CCur function;

CCur([Price]*1.1)

 

[Tom van Stiphout]

On Sat, 24 Apr 2010 10:36:20 -0500, "Jill" <[email protected]>
wrote:

Currency values have 4 decimals internally.

You can choose to display 2 decimals by using the Format and
DecimalPlaces properties, or using the Format function.

You can round values (e.g. from 4 to 2 decimals) by using the Round
function. You may want to search the web for "Bankers Rounding" to
read about the finer points of rounding.

-Tom.
Microsoft Access MVP