I’m sorry Jennifer, but I cannot help you with this, as I do not use Access. I use OpenOffice.org Base, and the SQL, and commands, are not the same as for Access.
Hopefully someone with Access knowledge can write the SQL script, and and send it to you (with instructions) as you requested. Ron Ferguson http://www.fergys.co.uk/ -----Original Message----- From: Jennifer Crockett Sent: Thursday, April 19, 2012 10:44 AM To: [email protected] Subject: RE: [LegacyUG] Baptism event Thanks Ron. I would like to give the Access method a try. I have the program, but would need instructions, off list probably, if you or anyone else would like to tell me how. Regards, Jennifer -----Original Message----- From: Ron Ferguson [mailto:[email protected]] Sent: Thursday, 19 April 2012 5:06 PM To: [email protected] Subject: Re: [LegacyUG] Baptism event Jennifer, I know of know no way of doing this without using Access. Personally, I would be tempted to leave it as is, and just make the changes when verifying the data a introducing a record into my main file. Ron Ferguson http://www.fergys.co.uk/ Jennifer Crockett <[email protected]> wrote: >I have received a file from a TMG user who converted it into a Legacy >compatible file. I opened it as a separate Legacy file and need to tidy it >up quite a bit. > >One thing is that all the Baptism events have ended up in Events/Facts and I >want to convert them to be listed with the main data under Born. I know how >to do this individually, but there are hundreds. Any ideas on how to do it >more easily and quickly? > >Regards, > >Jennifer >http://colston-wenck.com Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
