What I’m trying to is a little difficult to word, so bear with me please!
I’m adding a chart to my Access report to show how our production values have changed from week to week. My boss hates that the axis of the chart shows the weeks in their numbered form, like 51, 52, 1, etc. We define our weeks by Friday’s date and I’d like to see those dates on that axis. I couldn’t see how to do it just with the chart, so I figure it would be best if I can write an expression in the query itself to give me that Friday’s date, then I can use that column for the axis on the chart.
Does anyone have any idea how I could write an expression like that? Or how I could set the date differently on the chart?
