Thanks again Chris. I will have a go. It is people like you that really make novices like me understand better and appreciate the time and effort you apply to the questions on this site. Keep up your good work Regards Roger "Chris2" wrote: "Roger Bell" <RogerBell@discussions.microsoft.com> wrote in message news:3B06ABD7-8AD5-4D19-811B-81BAF6639C4D@microsoft.com... Thanks

Thanks for that Chris. As I am really a novice, do I write a new query and compose in SQL mode? What sort of query would I use to update/change the address details in the other data base for an existing record that already has address details. The fields are Unit, Unit Number, Street Name, Suburb. The two data bases are called MemberP and MemberH and contain similar information. How would

YTC#1 wrote: On Tue, 05 Sep 2006 15:27:10 +0100, Austin Shackles wrote: On or around Tue, 5 Sep 2006 11:23:04 +0100, Lozzo <lozzo@lozzo.org.uk> enlightened us thusly: mike. buckley says... In message <4m32eaF4a4gcU1@individual.net>, Steve Parry <k100rs_1990removethis@hotmail.com> writes .... you don't see every day ;) http://inline4.motorrijden