Access 2000
Hi All,
I am trying to create a calendar report of activities.
I would like to group on the calendar weeks. All weeks need to appear whether there is an activity during that time or not.
Field= [ActualDate]
My sort/Group is set to
[ActualDate] - ascending
Group Header -Yes
Group Footer - No
Group on - Week
Group Interval - 1
Keep Together - No
I have placed a text box [txtWeekOf] in the [ActualDate] header
Control Source =Min([ActualDate]) & "Thru..." & Max([ActualDate]
My Problem
My [txtWeekOf] only displays (obviously) the records in the table that match the control. I need the [txtWeekOf] to display the beginning and end date af the calendar year:
8/20/2006 Thru... 8/26/2006 and only display (in the Detail Section) the records that fall on or between those dates
8/27/2006 Thru... 9/2/2006 and only display (in the Detail Section) the records that fall on or between those dates etc.
TIA
Detrie
Hi All,
I am trying to create a calendar report of activities.
I would like to group on the calendar weeks. All weeks need to appear whether there is an activity during that time or not.
Field= [ActualDate]
My sort/Group is set to
[ActualDate] - ascending
Group Header -Yes
Group Footer - No
Group on - Week
Group Interval - 1
Keep Together - No
I have placed a text box [txtWeekOf] in the [ActualDate] header
Control Source =Min([ActualDate]) & "Thru..." & Max([ActualDate]
My Problem
My [txtWeekOf] only displays (obviously) the records in the table that match the control. I need the [txtWeekOf] to display the beginning and end date af the calendar year:
8/20/2006 Thru... 8/26/2006 and only display (in the Detail Section) the records that fall on or between those dates
8/27/2006 Thru... 9/2/2006 and only display (in the Detail Section) the records that fall on or between those dates etc.
TIA
Detrie
