Unanswered: Creating a query that groups data by week
I am trying to write a query that outputs information and gives me weekly totals. There are calculations involved in the data that will have to use the weekly sum to output calculated fields. I can do this in a report using the wizard (it will calculate the sums and then I add new text boxes that use the calculated sums to calculate averages and so forth), but can't seem to write a query that does the same thing. I don't know how to write in VB, so I need to know if this is possible using the existing query engine of MS Access.