grouping date range by week

[SteveGr]

I would like my query results to total my field by weekending date for a rolling year.

I am able to query a rolling year using the below criteria.
criteria: Between [Forms]![fmRptOpt]![txEndDt]-365 And [Forms]![fmRptOpt]![txEndDt]

But it returns every day. How do I make it return by weekending date?

Thanks Stevegr

 

[namliam]

i am unsure as to your question, but to calc a 'real' year:

Dateadd("yyyy",-1,date())

try doing a group by thing

Regards