Round numbers

[sandrao]

Is there anyway to disable the Round Numbers feature. It seems that
it rounds to three decimal places.

However when you look at the number it APPEARS to be $10.00 but in
reality it could be something like
$100.0012.

This may be alright for some items. But is you want to elimate items
that appear to be $0.00. These items could be anything e.g. $0.004,

 

[John W. Vinson]

Is there anyway to disable the Round Numbers feature. It seems that
it rounds to three decimal places.

However when you look at the number it APPEARS to be $10.00 but in
reality it could be something like
$100.0012.

This may be alright for some items. But is you want to elimate items
that appear to be $0.00. These items could be anything e.g. $0.004,

A Currency datatype is always stored with exactly four decimal places, no
more, no fewer. I'd suggest that you use the Round() function to round all
calculations to two decimals (or to the dollar if you wish).

Alternatively, rather than a criterion of 0.00 to eliminate "zeros", use a
fuzz factor such as

 

[sandrao]

A Currency datatype is always stored with exactly four decimal places, no
more, no fewer. I'd suggest that you use the Round() function to round all
calculations to two decimals (or to the dollar if you wish).

Alternatively, rather than a criterion of 0.00 to eliminate "zeros", use a
fuzz factor such as

So, would by code look like Round([MyField],2) to round to 2 decimal
points. would this be placed int the afterupdate of that field?

How would you use "fuzz Factor" in the code?

 

[John W. Vinson]

A Currency datatype is always stored with exactly four decimal places, no
more, no fewer. I'd suggest that you use the Round() function to round all
calculations to two decimals (or to the dollar if you wish).

Alternatively, rather than a criterion of 0.00 to eliminate "zeros", use a
fuzz factor such as

So, would by code look like Round([MyField],2) to round to 2 decimal
points. would this be placed int the afterupdate of that field?

No.

You are (somewhere, you don't say where, and I don't know where) calculating
the value that appears to be 10.00 but isn't.

You need to use the Round() function in the expression where you do that
calculation.

How would you use "fuzz Factor" in the code?

In a Query where you're trying to find records with a value of zero, but you
know that they are not in fact exactly zero, use a criterion of

-0.01 AND < 0.01

to select all records from -0.0099 through +0.0099.

 

[sandrao]

So, would by code look like Round([MyField],2) to round to 2 decimal
points.  would this be placed int the afterupdate  of that field?

No.

You are (somewhere, you don't say where, and I don't know where) calculating
the value that appears to be 10.00 but isn't.

You need to use the Round() function in the expression where you do that
calculation.

How would you use "fuzz Factor" in the code?

In a Query where you're trying to find records with a value of zero, but you
know that they are not in fact exactly zero, use a criterion of

   > -0.01  AND  < 0.01

to select all records from -0.0099 through +0.0099.

Thanks, All seem to working just as I wanted