Combine multiple UPDATE queries

[jimward]

I would like to combine 4 UPDATE queries into a single query but don't know how. The four queries are:

UPDATE tblToDeeds INNER JOIN tblProperties ON tblToDeeds.ToDeedID = tblProperties.PropID SET tblToDeeds.TransfDate = [tblProperties].[OwnDate];

UPDATE tblToDeeds LEFT JOIN tblProperties ON tblToDeeds.ToDeedID = tblProperties.PropID SET tblToDeeds.ToDeed_Text = [tblProperties].[Deed];

UPDATE tblProperties RIGHT JOIN tblToDeeds ON tblProperties.PropID = tblToDeeds.PropID SET tblToDeeds.FromDeed_Text = [tblProperties].[Deed];

UPDATE tblToDeeds SET tblToDeeds.TransfDate_text = CStr(Format([TransfDate],"yyyy/mm/dd"));

Can anyone help?
Thanks in advance
Jim...

 

[theDBguy]

Hi Jim. If you're updating multiple tables, I don't think you'll be able to use just one query. You may need a separate query for each table. I could be wrong though.