J
Jim
Sorry for re-posting this but I though maybe my title - typo was putting
people off.
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 a single quote (') 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
people off.
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 a single quote (') 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