syntax error (missing operator) in query expression - Access16

Question

I am getting the following error message when attempting to save or run a SQL query in MS Access 2016:

"Syntax error (missing operator) in query expression 'M.ScheduleKey FROM Actual_Data A'

The Query is:

UPDATE Actual_Data
SET A.ScheduleKey = M.ScheduleKey
FROM Actual_Data A, Match M
WHERE A.ActualKey = M.ActualKey

Both the ScheduleKey & ActualKey fields are text fields.

Any help on resolving this would be greatly appreciated.

AHeyne · Accepted Answer · 2019-03-13 08:05:58Z

1

You can use this instead:

UPDATE Actual_Data A
INNER JOIN Match M
ON A.ActualKey = M.ActualKey
SET A.ScheduleKey = M.ScheduleKey

answered Mar 13, 2019 at 7:31

AHeyne

3,5052 gold badges13 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1