Pivot Chart

[Phoenyxsgirl]

I have created a pivot chart that goes by each week and shows the number of people working. The only problem I am having is that the week headers show as the week # .. like 1 2 3 .. 51, 52, 53 ... I need them to show something like "11/6/11 to 11/13/11" or even just the end date or beginning date of the week.

Any suggestions? and yes, I'm going to feel really stupid if the answer is right under my nose and I just can't see it

[June7]

Calculate the week end date for each record in a select query then use that field as the Column header field in the pivot chart.

Assumes Sunday begins the week.
[yourdate]+7-Weekday([yourdate],1)

[Phoenyxsgirl]

that would calculate the current week ending date. How would I calculate the future week ending dates? If I have a table with them in it, how do I use those fields?

[Phoenyxsgirl]

Here is a picture of the graph. You can see on the bottom it says the numbers. I want that to say the date of the last day of that week.

[June7]

Use whatever date fieldname you want in place of [yourdate].