Update Query ?

[ShaneBrennan]

Okay.

I have an original table called tblResults. I select the records I require and copy them in another table tblTempResults.

I make amendments and additions to tblTempResults and I wish to put this information back into tblResults.

Can anyone help me on this one. Need SQL code.

Thank you in advance for any help

Shane
Shane Brennan
Shane.Brennan@tcat.ac.uk

 

[DISI]

I typically do this sort of thing using an update query. If you need the SQL here is an example assuming you have identical field names in both tables: "Update TblResults INNER JOIN TblTempResults on TblResults.ID = TblTempResults.ID Set TblResults.field1 = [TblTempResults].[Field1], TblResults.Field2 = [TblTempResults].[Field2];"

Paul Faculjak
paul@DataIntegritySolutions.com