Help with grouping

[RachelBedi]

I need to write a query which takes the previous month's audits and groups them together by Week 1, Week 2 etc



Here is the SQL I have for the AuditDate field;

AuditDate: DatePart(w,(Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)

However I'm getting a syntax error, I'm not even entirely sure that I'm handling this correctly.

Could anyone offer some advice?

Thank you!

[RachelBedi]

sooo I ended up working around this by adding in an additional column for the week number Week: (DatePart("ww",[AuditDate])) and grouped by that column - works