title: Why is my query not updateable?
body: <p>I'm trying to build an updatable view in Access for a user. Basically, the underlying tables look like this:</p>
  
  <pre><code>Accounts
  --------
  accountId
  accountName
  accountHolder
  
  TransactionStatements
  ------------
  statementId
  accountId
  received
  month
  year
  </code></pre>
  
  <p>The user wants a Query (view) that looks like this:</p>
  
  <pre><code>StatementView
  -------------
  accountName
  accountHolder
  year
  janReceived
  febReceived
  marReceived
  etc...
  </code></pre>
  
  <p>The SQL to accomplish this is straightforward using a transpose, but the resulting view is not updatable. </p>
  
  <p>I've also tried doing multiple joins explicitly to accomplish this:</p>
  
  <pre><code>PARAMETERS [Enter Year:] Long;
  SELECT accountName, accountHolder, year, 
  FROM ((Accounts a
  INNER JOIN TransactionStatements ts1 ON a.accountID = ts.accountID) 'AND month = 1 (This isn't allowed for some reason?)
  INNER JOIN TransactionStatements ts2 ON a.accountID = ts.accountID) 'AND month = 2 (This isn't allowed for some reason?)
  WHERE ts1.month = 1 AND ts2.month = 2 AND ts1.year = ([Enter Year:]) AND ts2.year = ([Enter Year:])
  </code></pre>
  
  <p>But once again the result becomes non-updatable as soon as I add the second INNER JOIN. I've looked at this <a href="http://office.microsoft.com/en-us/access-help/when-can-i-update-data-from-a-query-mdb-HP005188001.aspx" rel="nofollow">MS help page</a>, but it hasn't helped me figure out the right way to do this. </p>
  
  <p>It suggests Forms as an alternative, but building a custom form in Access appears to be an even more arcane and convoluted process than writing views.</p>
  
  <p>Any suggestions? </p>