Hi, i keep getting the error displayed in the title.
I ma doing a pretty simple query. Just finding a value in one table and inserting it into another.
Does someone know why access does not like it please?
I ma doing a pretty simple query. Just finding a value in one table and inserting it into another.
Does someone know why access does not like it please?
INSERT INTO tblExtend (extendContractID, extendMonths ) VALUES ( (SELECT conID FROM tblContract WHERE conMobileNumber = '5454545'), 12 )