I have the folowing Query that selects distinct values from a temp table and creates a new table.
Select distinct [LFILE_temp].[mfo], max([LFILE].boxes), INTO [LFILE_main]
GROUP BY [LFILE_temp].[mfo]
How can i turn this query in to an update query so the previous data in LFILE_main isnt being replaced every time the query is run?