Charts - Week ending

[Riviera*]

I have produed a chart in Access which has week numbers (1 - 52) on the x axis. The chart will display week 1, week 2 etc.. Instead of the week number I want the date of the week commencing displayed on the x axis.

Any ideas.

Thanks.

RiV.

 

[ebkid]

Do you wish to fix the problem in Access or Excel?

In Access you could do

DateValue("1/1/2003")+(WEEK_NUMBER*7)-7


or something along those line where WEEK_NUMBER is the value you are generating and 1/1/2003 is the first report date you wish to show

You could generate the 1st of the year date by doing

DateSerial(Year(Date()),1,1)

If you which to do the conversion in excel you can do a simular calculation
=B$3+(A4*7)-7
Where B3 contain the first date (1/1/2003) and A4 down contains the weeknumbers.

Hope this helps.

ebkid