weekly data from a query

[Anon]

I can get a monthly total from a query using the sigma sum. Can you please tell me how I get a weekly data from a query. I have date 1st through 31st and I want to sum the weekly totals

[Anon]

SELECT * FROM TABLE WHERE DATE=WEEK(NOW())

this will return everything where the field "date" is within this week.