Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top