Subgrouping Dates

[Compnstuff]

I need to be able to create a report that groups information by week (M-F). Is there a way to select an end date, say 6 week forecast, then have the report type totals for each week and give a grand total. Also can it give the dates as a group heading.

Any information would be helpful.

TIA,
Comp

 

[allanon]

The key to making this work would be to set up a query with the week number in it. Something like this:

SELECT MyTable.*, DateDiff("ww", "1-1", MtTable.MyDate) as WEEKS
FROM TyTable

Note: The DateDiff("ww", "1-1", Now()) is straight out of access help.

Then you will have a table with the week on it and you can create reports group and based on week, can select a certain week or span of weeks, etc.