On Sun, 23 Jan 2011 17:38:41 -0500, <sarge1...@cox.net> wrote: >(1) I changed the 'test.fdb' to 'test.mdb' and opened 'test.mdb' in Access, >where I tried to prepare a query to 'append one field to another'. Results - >I am unable to figure out how to do that with my limited knowledge and a book >that presumes more knowledge than I possess;
Try something like this query... UPDATE tblSR SET tblSR.SrcTitle = [tblSR]![SrcTitle] & " - " & [tblSR]![FilingRef] WHERE (([tblSR]![FilingRef]<>"")) Make a backup first (sounds like you already have). -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
