access chart data table number format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have problem in the number format when displaying the data table with the
chart. My data is from a table, the format is in percentage with 2 dec.
However, it displays as .098 in the data table instead of displayed as 9.8%.
I tried to change the number format with the data sheet, it only shows
correctly in design view, but not in data view. I also go into the property
of the chart, and assign the value format to %. but it still does not work.
I don't know how to alter the SQL statement. Is there a way to fix this?

I appreciate any help that I can have. Thank you!
 
Have you tried the Format() function in the SQL statement?

SELECT Format(percent_column, "Percent") As Pct, ... etc. ...
 
Back
Top