I have a Report that shows the following:
1) Name of Claim Processor
2) Total Claims Processed
3) Total Errors in Claims Processed
The criteria for the select query underlying the report is a date range (ProcessedDate) which is entered from a form that the end user accesses. This date range is typically for a month, for example 05/01/2013 through 05/31/2013.
Here is the issue I'm having trouble with, the user wants to see items 1, 2, and 3 above summarized by the WEEK in addition to a grand tally for the month (or whatever the date range is).
I have no problem getting the individual dates for each week within the month/date range, however, I can't figure out a way to dispay the grouping by week separately on the same report. Is it possible to have multiple text boxes with each text box's control source set to a different DLookup function or SQL Select query that restricts by the weekly dates? For example:
Week of 5/6/13 thru 5/10/13 Processor | #Claims | #Errors
Week of 5/13/13 thru 5/17/13 Processor | #Claims | #Errors
Week of 5/20/13 thru 5/24/13 Processor | #Claims | #Errors
Week of 5/27/13 thru 5/31/13 Processor | #Claims | #Errors
Thanks in advance for any ideas on how I can approach this!