Robin-
I don't see anything wrong with that except I would have done the INNER JOIN
the other way around for clarity -
UPDATE tMembers INNER JOIN EmailAdd ON ...
What is the parameter value it is asking for? When you get prompted with a
parameter in a simple query like this, it usually means you have misspelled
a field or table name.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Monday, May 06, 2013 8:26 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar