Update Query

[Legends77]

Sorry if this is a duplicat post but had a "glitch" and explorer went "mad" for a moment.

Having a problem getting a update query to work properly and think it is a simple fix but unable to find any examples to go by.

Need to update the field PPM on the table MonthlyPPM with the data from field MPPM in query3. Criteria would be query3.fy = monthlyppm.year and query3.monthID = monthlyppm.monthno

Any ideas or suggestions are greatly appreciatated and thanks in advance for any help.

 

[dhookom]

You would need to join on primary and foreign keys or at least a unique value from one of the tables.

If you can't define that in your query, you should be able to use the much slower DLookup() type expression.

If you can't figure this out on your own, you need to reply back with more information about your tables and fields.

Duane
Hook'D on Access
MS Access MVP

 

[Golom]

Try something like

UPDATE MonthlyPPM INNER JOIN query3
       ON query3.fy = MonthlyPPM.year 
          AND query3.monthID = MonthlyPPM.monthno

SET MonthlyPPM.PPM = query3.MPPM