No rounding

  • Thread starter Thread starter Stacey
  • Start date Start date
S

Stacey

Hello:

I have a table with currency in it. If I put $1423.45, it
rounds to $1423. If I put $1423.65, it rounds to $1423. I
want to keep the currency exactly as I put it in there.
Can someone please tell me a simple way to do this. I'm
not a programmer.

Thank you
 
Stacey said:
Hello:

I have a table with currency in it. If I put $1423.45, it
rounds to $1423. If I put $1423.65, it rounds to $1423. I
want to keep the currency exactly as I put it in there.
Can someone please tell me a simple way to do this. I'm
not a programmer.

Thank you
Click to expand...

Is the Data Type of the field (in table Design view) defined as
Currency? Note that the data type is different from the Format
property, which may also be defined as Currency. You *must* define the
data type as Currency, not as Number.
 
This probably has nothing to do woth rounding at all. Right click the cell
and select formatting and make sure for number format you have currency
selected and the number of decimal places you need. See if that works for
you.
 
Hello: I can see it in the table correctly but it is still
rounding in the report. Is it something I'm doing? I
didn't build this database.
 
Hello: I can see it in the table correctly but it is still
rounding in the report. Is it something I'm doing? I
didn't build this database.
Click to expand...

If it's correct in the table, then either it's the report or the query
the report is based on. Most likely, the report has just applied a
format to the text box or set its Decimal Places property to 0.
Possibly, the query has applied the Round() function or its equivalent.
 
Back
Top