query

P

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.
 
K

KARL DEWEY

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