Too many numbers past the decimal

[Jacques]

I have a query with a field that is set to Standard and 2 decimal places in
the properties. When you click on some records in that field, it shows
several digits past the decimal as opposed to just two.
I need the field to contain only the value of the two decimal places.

The form, that does math, pulls from the query and the math is incorrect
because its using actual values being held, not the two decimal place
numbers being shown.

Doesn't anyone know how to correct this?

Thanks beforehand.

Jacques

 

[Guest]

If I understand correctly,
If you have set that field property on the table level and haven't made it
as part of a calculated field in the query that the form is pulling the value
from then you again need to set the same property settings to Standard and 2
decimal places on the form level.
Hope that helps.

 

[Marshall Barton]

I have a query with a field that is set to Standard and 2 decimal places in
the properties. When you click on some records in that field, it shows
several digits past the decimal as opposed to just two.
I need the field to contain only the value of the two decimal places.

The form, that does math, pulls from the query and the math is incorrect
because its using actual values being held, not the two decimal place
numbers being shown.

Doesn't anyone know how to correct this?

It seems like you want to sacrifice accruacy for the sake of
appearances. If you're sure of that, use a calculated field
in the query.

AdjustedValue: Round(thefield, 2)

 

[Jacques]

The numbers are coming from a calculated field in a query. The query itself
will show up to 8 numbers past the decimal when its clicked on.

The table, query, and form are all set to two decimal places.
I'll give an example using two of the fields in the form.

Field A when clicked shows 1,271.0294
Field A when not-clicked-on shows 1,271.03
Field B when clicked shows 11,945.7648
Field B when not-clicked-on shows 11,945.76

Field C is A + B
Field C when clicked shows 17,158.8966
Field C when not-clicked-shows 17,158.90

The values being shown don't add up to the total values being shown.
The printable report needs to show the total values being shown, and of
course need to be accurate (but only to the second decimal place).

I've tried the #,###.## format, but it doesn't make the actual value change.
I've also tried changing the formats (on all objects) to Fixed, and Currency
(currently set to Standard), but this setting is really just a format.

 

[Jacques]

That actually seemed to work in one part.
The form with calculated fields is doing it by itself (even though every
field is set to 2 decimal places). Is there a way around that without
having to tell every field in the DB to Round?

 

[Marshall Barton]

The DecimalPlaces setting is just a shorthand formatting
thing, it has no effect on the actual value. If I
understand your complaint, you want the formatted
(automatically rounded for display purposes only) values you
see in a form/report to add up (using pencil and paper) to
the sum of the total using the Sum function. If that's what
you want then you can don't have to mess with each field.
Instead, use Sum(Round(fieldname, 2))