Hey gang, trying to learn how to code a query for selecting data to be displayed in a report result by daily,weekly and monthly stats.

Example of how it will display:

Daily: typical 7 day chart.

12/20 / 12/21 / 12/22 / 12/23...etc.
total this: 0 / 0 / 0 / 0 ...etc.
total this: 0 / 0 / 0 / 0 ...etc.
total this: 0 / 0 / 0 / 0 ...etc.

Weekly: 4 week chart.

wk1 / wk2 / wk3 / wk4
total this:
total this:
total this:

Monthly: quarter annual chart.

sept. / oct. / nov. / dec.

total this:
total this:
total this:

I know it seems redundent but, I need the totals from the the 7 individual daily records to sum up for the week's total production result. Then, the same thing to happen with the weekly totals to display as the month to month totals.

I know how to use the 'sum' command which should handle that part for me but all the help I can get is absolutely appreciated.

Thanks in advance, you guys are outstanding and I've learned a ton.