title: setting a field in SQL with the product of other field values
body: <p>I am trying to change update a field with the product of 3 other fields while using an update control button in Visual studio on this table my code and table follow does anyone know the correct syntax
  I am just now learning SQL for access`</p>
  
  <pre><code> SELECT (student_Score1 + student_Score2 + student_Score3) / 3 AS student_Avg
       FROM     Student
    UPDATE Student
   SET         [ student_Grade] = 'A'
                    WHERE  [student_Avg] = '[90 100]';
     SET          [student_Grade] = 'B'
     WHERE  [student_Avg] = '[80 89]';
    SET          [student_Grade] = 'C'
     WHERE  [student_Avg] = '[70 79]';``
    SET          [student_Grade] = 'D'
    WHERE  [student_Avg] = '[60 69]';
    SET          [student_Grade] = 'F'
    WHERE  [student_Avg] = '[1 59]';
  </code></pre>