-
Category Axis Label - PLEASE HELP!!
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.
-
Try using Format([ServiceYear),"#0-00") for the field containing "2-10" - should force Access to treat it as a text value.
-
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.
-
What is the data type of the field?
-
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules