access chart number formats

[jtkjames]

i have a chart powered by a query, and can't seem to get number formats (the chart has a data table) to stick. i have tried setting them in query design mode and in the datasheet.

is there some way i am missing? is there any sql code i can use to "force" the fields to be rendered as particular formats (such as percentage, currency)?

a scour of the net doesnt seem to yield anything helpful

 

[vbaInet]

If all you want to do is format a field, you can do so from within a query by using the Format() function:

http://www.techonthenet.com/access/functions/numeric/format.php

 

[jtkjames]

If all you want to do is format a field, you can do so from within a query by using the Format() function:

http://www.techonthenet.com/access/functions/numeric/format.php

worked a charm!

 

[vbaInet]

Glad to hear