Updating access query data with another table/ query?

[Michael_Red]

Hi
We have a query that creates a report. However when the query is run we have to make a number of manual adjustments, because the data that is table is incorrect. We cant update the data that is in the query so each time we run this report we have to manually adjust the data. So fro example ref 1234 shows as payment of 454, when it should be 545. There are around 35 adjustments that need to be made. I have all the adjustment in an table linked to an excel file. Is there a wait I can link that to the query if a match if found on the reference use the data in the other table? If no match use the original data? I tried using an update query with little success.

Cheers
Michael

[ranman256]

An update query is exactly what to use.
the attached XL file behaves as a table to run the update.
what about this doesn't work?

[Michael_Red]

Thanks. When I link them its not pulling the data I expect. Im linking the query to the table, and its only pulling data from the table. The table only contains 35 records where as the query contain over 200.

[Michael_Red]

thanks I was using the wrong joins