G
Guest
I'm very new to Access and would appreciate if someone would tell me exactly
where (and how, if possible) within the Query Design View I would set the
query field properties for a rounding problem.
I've set up an averaging query calculation that is rounding to 2 decimals,
but when I click anywhere else within the query results, the answer changes
to 3 decimal places, which is the correct result. However, since it will not
be used for actual accounting purposes, I would like it to round to 2
decimals and format as currency for my report purposes. I should say that my
underlying table field is set to Currency data type and Currency/Auto in the
Field Properties. I tried changing this to 2 decimal places, with no
success.
Thanks for your help
where (and how, if possible) within the Query Design View I would set the
query field properties for a rounding problem.
I've set up an averaging query calculation that is rounding to 2 decimals,
but when I click anywhere else within the query results, the answer changes
to 3 decimal places, which is the correct result. However, since it will not
be used for actual accounting purposes, I would like it to round to 2
decimals and format as currency for my report purposes. I should say that my
underlying table field is set to Currency data type and Currency/Auto in the
Field Properties. I tried changing this to 2 decimal places, with no
success.
Thanks for your help