Recent content by Sybilla

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

I have a basic question from what you're working with - is that the correct syntax to query weekly reports? WHERE (((WorkoutEntry.[Workout Date])=DateAdd("d",-(7),Date())))

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?