J
Joe
Hi,
i have these 2 tables called "Members" and "info." i would
like to transfer the information in from the field "name"
in "members" to the "name" field in the table "info" only
where i have a box checked. i have prepared the following
SQL statement to be run in a macro:
UPDATE [Info] SET [Info].NAME =[Members].NAME
FROM [Members]
WHERE (((Members.ResponseCheckBox)=Yes));
i keep getting a syntax error saying "missing operators"
i would greatly appreciate it if someone could proofread
this for syntax. Thanks a lot everyone!
-joe
i have these 2 tables called "Members" and "info." i would
like to transfer the information in from the field "name"
in "members" to the "name" field in the table "info" only
where i have a box checked. i have prepared the following
SQL statement to be run in a macro:
UPDATE [Info] SET [Info].NAME =[Members].NAME
FROM [Members]
WHERE (((Members.ResponseCheckBox)=Yes));
i keep getting a syntax error saying "missing operators"
i would greatly appreciate it if someone could proofread
this for syntax. Thanks a lot everyone!
-joe