Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

List every week

Status
Not open for further replies.

LOgden

MIS
Aug 21, 2002
4
US
I need to group by every week's workdays, such as August 12-16, August 19-23, August 29-Sept 2, etc. I do have a date field in my data, but for some weeks it is blank and when the grouping is done, it doesn't seem to list weeks when it was not used. How do I get my primary group for the report to be generically every week and then get the dates in my date field to show under the correct week? Your help would be much appreciated. Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top