title: MS Access 2010 (Design View): return Monday of the current week with Monday as 1st day of the week
body: <p>I need to make my Access query always return the Monday of the current week. I have seen a few solutions on Google/StackOverflow but they are written in SQL and I am a beginner in creating Access queries (I am using the Design view to make them). </p>
  
  <p>Goal: The week should be considered as <strong>M T W T F S S.</strong> Then, the query should always return the Monday of the current week. Therefore, if it is Sunday, it should still return the Monday before, <strong>NOT</strong> the next week's Monday. Can anyone explain how to do this using the Design View in Access 2010?</p>