[AccessD] Max Date of Week

Hello All,

I can't seem to get the SQL for this...I have a date field...I need to group 
by week, but display the greatest date value in that week.

Any ideas?

Thanks,

Mark A. Matte

_________________________________________________________________
Don’t miss your chance to WIN 10 hours of private jet travel from Microsoft® 
Office Live http://clk.atdmt.com/MRT/go/mcrssaub0540002499mrt/direct/01/