What are the primary and foreign keys?
If you change the query to a regular select query, can you update the tClubs.Email column?
Duane Hookom MVP
MS Access
----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: robinski@mymail.net.au
> Date: Tue, 30 Apr 2013 10:08:35 +1000
> Subject: [MS_AccessPros] Failed update query
>
> I have an update query that does not execute.
>
> Just one field is to updated from another table. it does not give an
> error message and it foes not update!
>
> UPDATE ClubGmail LEFT JOIN tClubs ON ClubGmail.ClubName =
> tClubs.ClubName SET tClubs.Email = [ClubGmail]![email];
>
> What have I missed?
>
> Many thanks,
>
> Robin Chapple
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar