title: Unable to edit a query's results using multiple table references and "group by"
body: <p>I have a continuous form that displays a set of time ranges and an ID, that currently looks like:</p>
  
  <pre><code>T1     T2     ID
  ----------------
  09:00  09:15  1
  09:15  09:30  2
  09:25  09:50  3
  09:50  10:20  4
  </code></pre>
  
  <p>Each ID is unique to the row. My goal was to highlight any times that were clashing (in this example the rows with ID 2 and 3 clash since 3 starts before 2 has ended). I decided to do this using conditional formatting, so wanted a field in each row to indicate whether there was a clash present.</p>
  
  <p>I achieved this by using a query that referenced the dataset twice, allowing me to compare the rows to each other:</p>
  
  <pre><code>[a].[T1]&lt;[b].[T2] And [a].[T2]&gt;[b].[T1] And [a].[ID]&lt;&gt;[b].[ID]
  </code></pre>
  
  <p>Assigning this as a field to a query gave me something like this:</p>
  
  <pre><code>a.T1    a.T2   a.ID  b.ID  Clash  
  --------------------------------
  09:00   09:15  1     1     False
  09:00   09:15  1     2     False
  09:00   09:15  1     3     False
  09:00   09:15  1     4     False
  09:15   09:30  2     1     False
  09:15   09:30  2     2     False
  09:15   09:30  2     3     True
  09:15   09:30  2     4     False
  09:25   09:50  3     1     False
  09:25   09:50  3     2     True
  09:25   09:50  3     3     False
  09:25   09:50  3     4     False
  09:50   10:20  4     1     False
  09:50   10:20  4     2     False
  09:50   10:20  4     3     False
  09:50   10:20  4     4     False
  </code></pre>
  
  <p>And to remove all duplicates I used <strong>group by</strong> on the <strong>a.ID</strong> field and took the <strong>Max</strong> of the calculated field (0 or -1) so I got True, if it was ever present per <strong>a.ID</strong>. This gave me:</p>
  
  <pre><code>a.T1   a.T2   a.ID  Clash
  -------------------------
  09:00  09:15  1     False
  09:15  09:30  2     True
  09:25  09:50  3     True
  09:50  10:20  4     False
  </code></pre>
  
  <p>Almost perfect, however, due to this new calculated field, and the fact I am essentially grouping results, I am no longer able to edit Time1 or Time2 when viewing this final result in a continuous form view.</p>
  
  <p>Is there a way I can still edit the time fields and keep this new calculated field? Or maybe a separate way of handling clashes that allow me to provide visual feedback in the form view?</p>
  
  <p>I realise there is a lot here and I may not have explained something clearly, if this is the case please let me know.</p>
  
  <p>Any help is much appreciated.</p>