Missing operator error

[Matt117]

Hello,

I am attempting to use this SQL code in an access query to update the assigned to field for a maximum of 50 records where the fields Assigned to and GSOS Payable are both empty. Both fields are held on an existing table called GSOS Test.

here is the code I am using

UPDATE GSoS_Test
SET Assigned_to = Name
WHERE Assigned_to IS NULL AND GSOS_Payable IS NULL
LIMIT 50;

However this is returning a syntax error


I'm pretty new to SQL code to attempted to use bard to get me the SQL code, which is the code posted above.



Please help

[Welshgasman]

I never seen that limit clause in Access SQL?
However in whatever sql it works in I would expect limit =50 ?

https://support.microsoft.com/en-us/...4-e8dc3e460671