title: Error with the sum function in sql with Access
body: <p>I am trying to sum the total price from invoices (named Total_TTC in table FACT) depending on the code of the taker ( named N_PRENEUR in the two concerned tables) and store the result in the DEBIT_P column of the table table_preneur.
  Doing so i get a syntax error (missing operator) In access and can't seem to understand why. I tried other posts and the usggestions returned me the same error.</p>
  
  <pre><code>    UPDATE P 
  SET DEBIT_P = t.somePrice
  FROM table_preneur AS P INNER JOIN
   (
    SELECT
     N_PRENEUR,
      SUM(Total_TTC) somePrice
    FROM
       FACT
    GROUP BY N_PRENEUR
    ) t
  ON t.N_PRENEUR = p.N_PRENEUR
  </code></pre>
  
  <p>thx in advance</p>