Weekly Reports

[Sybilla]

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?

 

[Sybilla]

WHERE (((WorkoutEntry.[Workout Date])=DateAdd("d",-(7),Date()))) - is now what I've moved on to, but I'm still not getting results