>OK, so the 2nd grid doesn't need a grand total....it just needs totals summarized by week?
>Also, is your week based on Sunday to Saturday?
Both need totals, no matter if it is weekly. My week is based on Sunday first day. I use datepart(wk, date), it use client's machine?