Week to date and rank calculation

[Hans]

I have a database that is reporting sales totals for 25 stores on a daily basis. I would like to make a daily sales report that would tally week to date totals for each store, and rank them.
The week cumlative for the week are my problem. Where can I establish for example Feb. 7 = Week 6 --so I can set it up.
Also is there a best way to calculate rankings to display in a report?

 

[Flea]

Hans,

You can use the DatePart function to get the the week number: DatePart("ww", date). As for the rankings, the only thing I can think of off hand is to sort descending by a particular field.