SELECT Data By This Week

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;