Re: Update and Append Query

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: John Ortt (JohnOrtt_at_Idontwantspamsonoreturnaddress.com)
Date: 11/10/04 

Date: Wed, 10 Nov 2004 10:23:44 -0000

"John Ortt" <JohnOrtt@Idontwantspamsonoreturnaddress.com> wrote in message
news:4191e064$1_1@baen1673807.greenlnk.net...
> <Snip>
>
> > UPDATE Master RIGHT JOIN [Transaction] ON Master.[Trans ID] =
> > Transaction.[Trans ID] SET Master.[Trans ID] = [Transaction].[Trans ID],
> > Master.Name = [Transaction].[Name], Master.DOB = [Transaction].[DOB];
>
> Thanks Tom,
>
> I'll give that a try.
>

 Worked a treat.

Thankyou very much