Category Axis Label - PLEASE HELP!!

[JerseyNJ2008]

Hi,I have a bar graph that displays data according to service years ranges.The x-axis displays the service year ranges and the y-axis displays the total headcount for each service year range.The ranges are 20My problem is that access keeps converting my 2-10 label and 11-19 label to Feb-10 and 11-19. Is there anyway to prevent access from treating 2-10 as an actual date?????Please help me if know I can correct this.Thank You for your help.

[geekgirlau]

Try using Format([ServiceYear),"#0-00") for the field containing "2-10" - should force Access to treat it as a text value.

[JerseyNJ2008]

Hi,Thanks for your help. I tired your suggestion, but what happens is that it keep converting these ranges to some weired numbers.For example range 2-5 gets formated to 387-53.Format([ServiceRange],"#0-00")Would you know how to fix this? Thanks.

[geekgirlau]

What is the data type of the field?

[JerseyNJ2008]

The data type is text.

[geekgirlau]

Are you able to post a small version of your database? Just the table (and query if required) with a few records and the graph.