year_ = year(date())
month_ = month(date())
day_ = day(date())
newdate_ = year_&"-"&month_&"-"&day_
date1 = DateAdd("d",1-weekday(newdate_),newdate_)
date2 = DateAdd("d",7-weekday(newdate_),newdate_)
sql__ = "select * from YourTable where (StartDate>='"&date1&"' and StartDate<='"&date2&"') or (EndDate>='"&date1&"' and EndDate<='"&date2&"') or (StartDate<='"&date1&"' and EndDate>='"&date2&"') order by id desc"