group by week, display as date

[Guest]

I am trying to create a chart and datatable showing values grouped by week,
however displaying only the week numbers isn't very easy to read. Is there a
way to show a representative date for the week? I.E. group all data from the
week of 5/21/07-5/25/07 and display it as 5/25/07 on the chart/table?

 

[Guest]

You can change your week number expression to something like:
Week Of: DateAdd("d",-Weekday([DateField])+1,[DateField])

 

[Guest]

I had tried something similar, causing another problem. When I use a full
date like that in the row, it leaves spaces on the chart for all the unused
dates in between, creating a very empty looking and hard to read graph. Is
there a way to remove those gaps?

You can change your week number expression to something like:
Week Of: DateAdd("d",-Weekday([DateField])+1,[DateField])
--
Duane Hookom
Microsoft Access MVP

I am trying to create a chart and datatable showing values grouped by week,
however displaying only the week numbers isn't very easy to read. Is there a
way to show a representative date for the week? I.E. group all data from the
week of 5/21/07-5/25/07 and display it as 5/25/07 on the chart/table?

 

[Guest]

I'm not sure if you can remove the gaps. I would have to build the chart and
then play with various properties in much the same way that you would need to
test.
--
Duane Hookom
Microsoft Access MVP

I had tried something similar, causing another problem. When I use a full
date like that in the row, it leaves spaces on the chart for all the unused
dates in between, creating a very empty looking and hard to read graph. Is
there a way to remove those gaps?

You can change your week number expression to something like:
Week Of: DateAdd("d",-Weekday([DateField])+1,[DateField])
--
Duane Hookom
Microsoft Access MVP

I am trying to create a chart and datatable showing values grouped by week,
however displaying only the week numbers isn't very easy to read. Is there a
way to show a representative date for the week? I.E. group all data from the
week of 5/21/07-5/25/07 and display it as 5/25/07 on the chart/table?