How to set decimal places for a column in the report

[Karen Middleton]

I am defining a Access report which as its data source from a Access
query.

The problem I am facing is some of the Access query columns are
derived from the underlying tables and some of the columns in the
Access query are derived values like TotalSales = RebateSales +
UnRebatedSales eventhough I set the decimal places to say 2 or 0 that
seems to be applied by the Access reports only to the fields coming
from the tables in the Access query some of the derived columns in the
Access Query like TotalSales which is a calculated column the Access
report seems not to apply the decimal places to these derived columns
at all.

Can any of you please advice how I can overcome this problem so that I
am able to apply the decimal places to all kinds of columns coming
from the Access report.

Thanks
Karen

 

[Marshall Barton]

I am defining a Access report which as its data source from a Access
query.

The problem I am facing is some of the Access query columns are
derived from the underlying tables and some of the columns in the
Access query are derived values like TotalSales = RebateSales +
UnRebatedSales eventhough I set the decimal places to say 2 or 0 that
seems to be applied by the Access reports only to the fields coming
from the tables in the Access query some of the derived columns in the
Access Query like TotalSales which is a calculated column the Access
report seems not to apply the decimal places to these derived columns
at all.

Can any of you please advice how I can overcome this problem so that I
am able to apply the decimal places to all kinds of columns coming
from the Access report.

The only time the table or query formats are used is when
you add a new text box to the report by dragging the field
name from the field list to the report. Even then, the only
thing that happens is that the new text box's properties are
set to the field's format/decimals/etc.

The answer to your question is to go into the report's
design view and set the text box properties youeself.

 

[Guest]

Karen,
You can set the format of the report field in the porperties of the report.
Open your report in design view. Right click the field that you want to
fromat. On the properties dialogue box select format, then choose currency
(in the 'format' field )and Decimal places just below. Save and exit that
should solve the problem.

GarryD