If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
fomatting prices
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. |
#2
|
|||
|
|||
fomatting prices
Typecast the calculated fields as currency using the CCur function;
CCur([Price]*1.1) -- _________ Sean Bailey "Jill" wrote: 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. . |
#3
|
|||
|
|||
fomatting prices
On Sat, 24 Apr 2010 10:36:20 -0500, "Jill"
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 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. |
Thread Tools | |
Display Modes | |
|
|