title: calculating if date falls within a given range
body: <p>I'm working with MS Access 2010.</p>
  
  <p>I have a table of projects and each project has a STARTDATE, ENDDATE, and a True/False field for ACTIVE.  Active is true if today's date is within Start and End dates - and I want it to be automatically checked or unchecked.  </p>
  
  <p>How do I write this event in VBA??</p>
  
  <p>thanks!</p>