On Fri, 14 Apr 2006 13:25:25 -0600, "Don Cook" <[EMAIL PROTECTED]> wrote:
>P.S. I don't have Access and don't plan on going there! Don Then I can't think of a good way to do what you want. I am not even sure your idea of a Search & Replace on tagged groups (I assume you mean groups of individuals) or focus groups would do what you want. I suppose you are thinking of tagging all individuals who use a Census event, then performing a Search & Replace against these tagged individuals for an exact Event Date of 1787 and replacing it with Jun 1787. This might not work because these tagged individuals might have other events (different Event Type) with an exact date of 1787. You might get lucky, but you will still have to take a look at each replacement to make sure. Doing what you want in Access would look something like... UPDATE tblER INNER JOIN tblET ON tblER.IDET = tblET.IDET SET tblER.EventD = "000007178700000000", tblER.EventSD = 17870715 WHERE (((tblET.EventType)="Census") AND ((tblER.EventD)="000000178700000000")); P.S. Always backup before doing any updates with Access. -- Dennis M. Kowallek [EMAIL PROTECTED] ****************** Enter the drawing for a FREE Legacy Cruise to Alaska or a FREE research trip to Salt Lake's Family History Library. Open to users of Legacy 6 Deluxe. Enter online at http://legacyfamilytree.com/FreeTrip.asp Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ For online technical support, please visit http://www.legacyfamilytree.com/Help.asp To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
