Query Currency Field Decimal Property

  • Thread starter Thread starter Norman Brumm
  • Start date Start date
N

Norman Brumm

Hi y'all,

I'm having trouble with the Decimal property on a query
in Access 97. I have an item that has a standard retail
price. The price I want to display in this query is
anywhere between 10% and 20% of MSRP.

Once I change the field by adding calculations and quoted
text, the "Decimal" property disappears and my display
isn't proper currency any more. Sometimes it's three
decimal places (like $19.99 * .2 = $3.998 instead of
$4.00) or sometimes it's only one decimal place (like
$19.50 * .2 = $3.9 instead of $3.90).

I've been able to get around the three decimal place
problem using an "Int" funcion but I can't for the life
of me squeeze out an extra zero or two when I need it!

Thanks for any help,

Norman
 
Have you tried using the CCur (Convert to Currency) function?

e.g. CCur($19.99 * .2). The result should be $4.00.

HTH.
 
-----Original Message-----
Have you tried using the CCur (Convert to Currency) function?

e.g. CCur($19.99 * .2). The result should be $4.00.
Click to expand...

Yes I have. And I just now tried it again in different
spots. What seems to be causing the trouble is the fact
that I've added some quoted text in front of the
currency. I've got two examples and neither of them work
right:

"MSRP . . . " & [RetailPrice]
"Our Price . . . " & Int(20*[RetailPrice])/100

Is the quoted text indeed messing up all that? Is there
any way around that?

Thanks again,

Norman
 
Back
Top