Search results

I'm trying to run a query to for weekly reports - I've found the DatePart function, but not sure on syntax FROM WorkoutEntry WHERE ((WorkoutEntry.[Workout Date])=DatePart("ww",[Date()-WeekDay(Date())+1 AS StartOfWeek][,Date()-WeekDay(Date())+7 AS EndOfWeek] )) Any help?