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