Hi All,

I am making a report showing average % of different ages groups over
several years. I really need to use the data table as part of my
chart, but I can't because I can't get the numbers to format as
percentages. I have formatted everything I can think of, but nothing
works. Help!

Thanks,
:-)
Laura

musicloverlch wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use a query instead of the table as the chart's data source. You can
use the Format() function to display the value as a percentage:

Format(percentage_value, "Percent")

Format(.0025, "Percent") -> 0.25%

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBScwKx4echKqOuFEgEQLr5ACfZahZGXdgxuNNO6iYlKg4Jm dTUVIAn2S+
InPJocZhBQSFDHUQCs5FGVFM
=wvlT
-----END PGP SIGNATURE-----