title: Access 2007 Forecasting Date range
body: <p>I'm looking for some help / guidance on implementing some kind of forecasting form in my access database. What i'd like to achieve is for the user to pick out a project from a drop down list (which i have) and then select a from &amp; to date from two date pickers. When the dates are selected - e.g Jan 2016 - Jan 2017, the database creates 12 blank entries where the user can input various amounts in each cell. </p>
  
  <p>The database has the set up where a single project can have multiple calendar dates. I've tried using a cross tab query in the first instance however, as I quickly found out, it's non-updateable. I've looked into using a 'temp' table and then possibly using an update function from the temp table and inserting new records however, I'm really hoping there is a simpler way.. Has any one encountered a similar issue / any advice on the best approach?</p>
  
  <p>Update:
  Table structure of the temp table (if this is the best way?) would look something like:</p>
  
  <p>Ideally, if the user selects the range Jan 15 - Jan 16, then the database 'fills in' the remaining months. In the db the table would then look like:</p>
  
  <p><code>[Project Id] [Month] [Year]</code><br>
  <code>[1]            [1]    [2015]</code><br>
  <code>[1]            [2]    [2015]</code><br>
  <code>[1]            [3]    [2015]</code><br>
  etc..</p>
  
  <p>I'm unsure how to implement this; i.e on selection of starting and end months, create the entries in between. </p>