Prev: Change colour of a field
Next: unique records Access 2003
From: MKuria on 27 May 2010 17:08
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
From: Daryl S on 27 May 2010 17:58
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: Change colour of a field
Next: unique records Access 2003