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. ...

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Yolanda wrote:

> 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?