Rounding Chart Values

[Board2Death]

Access 97

I have created a report that contains a bar chart. I want to display the values each bar on the chart. When I select Value for the data labels it does display the values as expected. The value dispalyed has more decimal places than I would like. Is there any way to truncate it without haveing to rewrite the underlying query?

 

[IGPCS]

or you can use in the report the format (number,"Format I.E. 0.0000") or you can configure the decimals on the fields property in report design

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[Board2Death]

Not quite sure that I follow.

Where exactly would I use the format function?

Where is the fields property?

By the way...Thanks for your help with this.

 

[IGPCS]

the bond field on the report

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[IGPCS]

the field property is when you right click on the field and click the last line in the menu "Properties"

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY