how do I group query results by week?

[shopoholic]

Hi everyone

I need to run a query that returns the number of bookings made for each week so far this year. However the date is held in DD/MM/YY format. I had a similar query that worked fine for monthly grouping using Month([Start Date])AS FilterMonth but tried replacing month with week, this didn't work.

Any ideas?

Thanks!

 

[Pat Hartman]

Look up the DatePart() function or the Format() function.