SELECT *
FROM qry_Project_Tracking
WHERE (((qry_Project_Tracking.Project_Complete_Date) Between (Date()-Weekday(Date())+1) And (Date()-Weekday(Date())+7)))
ORDER BY qry_Project_Tracking.Project_Complete_Date DESC;