Update Query is not updating 1

[vba317]

I am working in access 2003. I have written an update query that won't update the column I need it to. What I am trying to do is I have the source table called dbo_dic_Period and the destintation table called z_ImportPeriods. What I want to happen is when dbo_dic_Period.pd = z_ImportPeriods.pdid copy the date from dbo_dic_Period.mon_shrm to z_ImportPeriods.mon. Right now I don't get any errors but the data is not going into the z_ImportPeriods.mon column. I have copied the SQL view of the query. Any help is appreciated.

Tom

UPDATE dbo_dic_Period INNER JOIN z_ImportPeriods ON dbo_dic_Period.pd = z_ImportPeriods.pdid SET dbo_dic_Period.mon_shnm = [z_ImportPeriods.mon];

 

[PHV]

UPDATE z_ImportPeriods INNER JOIN dbo_dic_Period ON dbo_dic_Period.pd = z_ImportPeriods.pdid
SET z_ImportPeriods.mon = dbo_dic_Period.mon_shnm




Hope This Helps, PH.
FAQ219-2884
FAQ181-2886