title: Access query doesn't allow edits to data
body: <p>I have a table that tracks communications between a call center and callers.  It has a number of fields and a memo field where notes can be entered.  I also have an automated process which transfers data with the client, and if an address update is made, it adds a communication note stating what the address was, and why it was changed.  The issue I'm having is we get data from two sources, and many times this includes the same people from both sources.  Often times there is only a tiny difference between two addresses (street vs st) and this causes multiple records to be created every month.  The analyst in charge of this client has a query to view records where multiple changes exist (specifically that were created by the automated census) so they can see which are duplicates and which are legit.  I want them to be able to check a box or in some way mark these records to be deleted.</p>
  
  <p>The problem is the resulting query is not editable because the query that helps feed it uses the count function so it isn't necessarily a one-to-one relationship with the table.  Here is the first query:</p>
  
  <pre><code>SELECT tblCommunications.RecordID, Count(tblCommunications.RecordID) AS CountOfRecordID
  FROM tblCommunications
  WHERE (((tblCommunications.CallComments) Like "*Updated address via Census feed.*"))
  GROUP BY tblCommunications.RecordID;
  </code></pre>
  
  <p>The second query does a <code>LEFT JOIN</code> with this first query and simply displays the table data for those records where <code>CountofRecordID</code> is greater than 4.  However, this final listing can not be edited, so the checkbox I added in to mark them for deletion can't be checked.</p>
  
  <p>Does anyone know how I can make this work, or perhaps have a better idea on how to approach this?</p>
  
  <p>Thanks!</p>