Access 2003

[DES]

I'm trying to write an expression in a querie that will calculate a 10%
reduction in the price of some items. I can't seem to get the answer to come
out as currency. The only fields I am using would be the old price times 1.10
How do I make the answer come out as currency?

 

[Douglas J. Steele]

You could use the CCur function.

 

[boblarson]

Also, calculation of a 10% price REDUCTION is not the old price times 1.10.
It would be

Old Price - (Old Price * .10)

so multiplying the old price times .1 for 10% and then subtracting that from
the old price.

 

[Douglas J. Steele]

Or just multiply the old price by .9