Update Query

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];
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com



"Itzkie" <Itzkie DeleteThis @discussions.microsoft.com> wrote in message
news:B3A73D4B-F3EF-423C-9299-3E43403CA5B2@microsoft.com...
> 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