title: Auto-generating reports in Microsoft Access
body: <p>Currently I am in the process of building an updated Microsoft Access database for our affiliated hospital to keep a timeline of documentation for potential medical studies. The database itself is standalone, so there is <strong><em>no</em></strong> real back end to speak of (which hurts me, but I have no control over how they handle their data). It currently holds only one table with all the necessary fields needed. I'm looking to have reports generate automatically every week, month, quarter, and year. However, I must admit my vba coding abilities are spotty at best. My questions are this:</p>
  
  <ol>
  <li><p>What code would I need to use to generate said reports?</p></li>
  <li><p>Would I need to create separate queries just for each type of report based on when it needs to be generated, or can I code it all in one query without the different codes interfering with each other?</p></li>
  </ol>
  
  <p>If any other information or clarification is needed, I'd be happy to give you what I can.</p>