J
Jim
I'm running Access 2003 on Win XP Pro.
On the category axis the source field has values of 01, 001, 00001, AB,
ABC etc. The problem is when the chart displays I get 1, ,1, 1, AB, ABC
etc.
I've changed the format of the axis to text and that seems to have no
effect.
If I change the query and put an ' in front of each field it displays
the entire 01 or 001 but with that ' out front. I know what its doing
but how do I get rid of it?
Any suggestions?
Jim
On the category axis the source field has values of 01, 001, 00001, AB,
ABC etc. The problem is when the chart displays I get 1, ,1, 1, AB, ABC
etc.
I've changed the format of the axis to text and that seems to have no
effect.
If I change the query and put an ' in front of each field it displays
the entire 01 or 001 but with that ' out front. I know what its doing
but how do I get rid of it?
Any suggestions?
Jim