How to present data in a chart

M

Marcus

Hi!
I want to make a chart in Access 2003 that displays the week of the year on
the X-axis. I also want to make the weeks year specific, for example week
five in year 2008 will be displayed as "08-05", week six in 2008 as "08-06"
and so on...

I guess that I have to choose a specific format for the data type in the
table where I store the weeks...

The problem I have is that even if I store the data as "08-05" in the table
(with the format: 00\-00), it is displayed as "805" in the chart. Do you have
any suggestions?

//Marcus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top