Hi Sir/Madam
I am usimg the forlloing SQL, but the records are not updating.
UPDATE MEMBERS SET MEMBERS.EL = [EL]+(DateDiff("d",[FORMS]![EMPLOYEE_LEAVE_MASTER]![TXTFROM],[FORMS]![EMPLOYEE_LEAVE_MASTER]![TXTTO])+1)
WHERE ((([FORMS]![EMPLOYEE_LEAVE_MASTER]![TXLV])="EL") AND ((MEMBERS.ACCOUNT_NO)=[FORMS]![EMPLOYEE_LEAVE_MASTER]![TXTAC]));
can you help me.
I am usimg the forlloing SQL, but the records are not updating.
UPDATE MEMBERS SET MEMBERS.EL = [EL]+(DateDiff("d",[FORMS]![EMPLOYEE_LEAVE_MASTER]![TXTFROM],[FORMS]![EMPLOYEE_LEAVE_MASTER]![TXTTO])+1)
WHERE ((([FORMS]![EMPLOYEE_LEAVE_MASTER]![TXLV])="EL") AND ((MEMBERS.ACCOUNT_NO)=[FORMS]![EMPLOYEE_LEAVE_MASTER]![TXTAC]));
can you help me.
Last edited: