Prev: Parameter Error for Year 2010
Next: unique records Access 2003
From: MKuria on 27 May 2010 15:56
Thanks Daryl,
I changed the SQL and it works.
--
mmk


"Daryl S" wrote:

> MKuria -
>
> Your update query is set up to update the [ChangeForm] fields. If you want
> to update the [AMT Per MAS] fields, then the query should look like this:
>
> UPDATE [AMT Per MAS] INNER JOIN [Change Form] ON [AMT Per MAS].ID = [Change
> Form].ID SET [AMT Per MAS]![FROM AMT] = [Change Form].[FROM AMT Assignment],
> [AMT Per MAS]![TO AMT] = [Change Form 2].[TO AMT]
> WHERE ((([Change Form].ID) Is Not Null));
>
> --
> Daryl S
>
>
> "MKuria" wrote:
>
> > I have created an update query to update a master file. When I run the
> > select query to view the records I need to update - I see the correct data.
> > When I change query to update query and enter the table to update and run
> > update query. The query is updating the source table (Change Form) instead
> > of table indicated (AMT Per MAS) to update to....Strange.. I am using Access
> > 2003
> > Below is the SQL.
> >
> >
> > UPDATE [AMT Per MAS] INNER JOIN [Change Form] ON [AMT Per MAS].ID = [Change
> > Form].ID SET [Change Form].[FROM AMT Assignment] = [AMT Per MAS]![FROM AMT],
> > [Change Form 2].[TO AMT] = [AMT Per MAS]![TO AMT]
> > WHERE ((([Change Form].ID) Is Not Null));
> > --
> > mmk
 | 
Pages: 1
Prev: Parameter Error for Year 2010
Next: unique records Access 2003