specify week in a quarterly report

  • Thread starter Slez via AccessMonster.com
  • 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!
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top