format

[sadie]

I am workling on a report in access 2000. I have a report on the kids in my group and one of the groupings is by age.
I have age ranges such as under 10, 11-12, 13-15 etc
In my report I count the number in each group but the weirdest thing happens. I inserted a chart and the legend comes up for the 2 "10-12" year olds as "12-Oct". Somehow it's seeing the 10 as October.
I assume it's a formatting problem...Any suggestions as to how to fix it
Thanks

 

[qurn]

Go into the table the query is based off of, go into design view and change the data type from date to text.

 

[sadie]

thanks I'll try