If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update Query not updating selected table
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 |
Thread Tools | |
Display Modes | |
|
|