Query

P

PJ

I have a report that under the "sorting and grouping option" it's summing
data by Qtr and Month under "Group On". Is it possible to do this in a
query? Thanks in advance.
 
D

Duane Hookom

You can create a totals query that groups by any date interval(s).

Keep in mind the sorting in a query has little effect on the sorting in your
report. You should always use the sorting and grouping dialog in report
design.
 
Top