group by week, display as date

R

Robert

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?
 
D

Duane Hookom

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

Robert

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?

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


Robert said:
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?
Click to expand...
Click to expand...
 
D

Duane Hookom

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


Robert said:
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?

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


Robert said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Top