specify week in a quarterly report

  • Thread starter Thread starter Slez via AccessMonster.com
  • Start date Start date
S

Slez via AccessMonster.com

I need to create a quarterly report that shows a sum of records for each week
along with the sum for each quarter. I'm envisioning something like this:

Week Total amount Quantity
1 $$$$$$ #
2 $$$$$$ #
3 $$$$$$ #
4 $$$$$$ #
...an so on...
13 $$$$$$ #
Total for Qtr $$$$$$$$$$ ###
...and continue on to the next quarter...

When I think of quarter, I think Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec.
How does Access percieve/arrange the data when, as an example, week 13 is
split between March & April?

One other question: When creating a quarterly report, does the DatePart ("q".
.. expression need to be used in the underlying query or can it be done right
in the report?

Thanks in advance for any feedback!
 
How do you want to handle weeks the span more than one quarter? Access
creates quarters by Jan-Mar, Apr-June....

You can choose Quarter as the "Group On" when you sort/group on a date field.
 
Back
Top