Update Query

I

Itzkie

How do I fill in the boxes for the table I want to update in an update query?
I can easily fill in the fields for the table to get the data from..

Thanks
 
A

Arvin Meyer [MVP]

Here's one way where there is a single field updating another:

UPDATE Table3 SET [Degree] = [Measurement] & Chr(176);

And here's one that uses a Join to get data from 1 table (query) to update
another:

UPDATE tmpRptProcessed INNER JOIN qryCurrentYearProcessed ON
tmpRptProcessed.RecordID = qryCurrentYearProcessed.RecordID SET
tmpRptProcessed.JRDRevenue = [qryCurrentYearProcessed2].[JRDRevenue];
 
Top