Decimal Places in Calculated query field

[Henry]

I realize that general numbers cannot be specified as to
number of decimal places. However, even when I specify the
format as fixed numbers, the program does not format the
resulting number according to specified decimal places --
full precision is displayed. In some of the calculated
fields (not all), I don't even get the option of
specifying decimal places, even for Fixed Number Format.
Any suggestions as to what the problem may be?
Henry

 

[Tom Ellison]

Dear Henry:

The problem may be that your query is returning numeric values. If
you ever want to be able to perform calculations on the values, this
is exactly the way they should be returned. If the values need to be
rounded, that's a simple matter.

Later, when you're ready to display the values on a form or report,
you'll want to specify the number of decimal places there. But the
way the values are displayed in the query, where the values are
numeric and not text, should not be of critical concern. Simply make
sure that the end users don't see the values in the query datasheet
form.

I realize that general numbers cannot be specified as to
number of decimal places. However, even when I specify the
format as fixed numbers, the program does not format the
resulting number according to specified decimal places --
full precision is displayed. In some of the calculated
fields (not all), I don't even get the option of
specifying decimal places, even for Fixed Number Format.
Any suggestions as to what the problem may be?
Henry

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts