Sorting Date entries into Weeks to get a Summary report summarizing totals into weekly totals
I have a DB with records providing billing amounts on case files. I want to get a report that provides this data into a summary report that displays the data breakdown into a weekly summary. I currently have a report that gives me a weekly total per biller, but need a report that will give me a weekly breakout depending on the date range I input. Example would be a report the provides totals for "Week of 10/4/09, Week of 10/11/09 and so on based on the daily entries.
Any scripting help would be appreciated.