[MS_AccessPros] Update query problem

 

I have caused my self a problem and I need to update email addresses
in our member list to the data in the previous back up copy.

I have made a table "EmailAdd" which is MemberID and any email
addresses that may be recorded.

I have attempted to use an update query and failed because it asks
"Enter Parameter Value". Those of you who have helped me earlier will
know that I have limited abilities.

This is the SQL

UPDATE EmaillAdd INNER JOIN tMembers ON EmaillAdd.MemberID =
tMembers.MemberID SET tMembers.Email = [EmailAdd].[Email],
tMembers.Email2 = [EmailAdd].[Email2], tMembers.Email3 = [EmailAdd].[Email3];

What have I missed this time?

Many thanks,

Robin Chapple

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3

Visit Your Group

MARKETPLACE

---

---

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___