Join doesn't appear to work

K

krc777

Registered User.
Local time
Today, 11:49
Joined
Nov 29, 2005
Messages
70
Can anyone tell me why this statement is not working?

CurrentDb.Execute "UPDATE MainRptDataASD INNER JOIN CHPs ON MainRptDataASD.PlanID = CHPs.PlanID SET MainRptDataASD.PlanName = CHPs.Plan"

I want to take the CHPs.Plan name and fill in those fields in the MainRptDataASD.planName

At this point it leaves them all empty.
Thanks.
 
You must log in or register to reply here.

Similar threads

P
Variable assignment not working.
2
Replies
22
Views
1,467
pdanes
P
T
Solved It takes too long to download data from server
Replies
16
Views
1,409
GPGeorge
GPGeorge
J
Solved SQL problem
2
Replies
29
Views
1,962
isladogs
isladogs
B
Update query doesn't like value formatted for a different region.
Replies
19
Views
2,165
Josef P.
J
A
Missing data when exporting from excel to Access
Replies
11
Views
1,157
Isaac
Isaac

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom