ACCESS FEED: RE: [MS_AccessPros] Update query problem

Senin, 06 Mei 2013

RE: [MS_AccessPros] Update query problem

At 6/05/2013 04:49 PM, you wrote:
>Robin-
> 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,

You are 100% right. I misspelled the temporary table name. "ON
EmaillAdd.MemberID ="

Email spelled with a double 'll'

Many thanks all is well.

Robin

>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
>
>
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>