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...
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...