query

[Pass-the-reality]

I need a query that will sum up totals for a week. The week can start on
either Sunday or Monday. The fields in my query are ID Number, OrderDate And
Item. I have set my Criteria for Item to only show the product type "PDP".
What I want to end up with is a query that counts up a weeks worth of records
and reports out something like this

Sept 8 20records
Sept 15 10 records

the total for Sept 8 would include the 8th through 14th.

 

[KARL DEWEY]

Use a totals query with this substituting your field for [datStart].
Work_Week: (([datStart]-1)-Format([datStart]-1,"w"))+2