On 10/02/2012 10:37, Alan Pereira wrote: > There is another way if you know how to use MSACCESS > Change the fdb extension to mdb > open in MSAccess > Create the following query in sql view > > SELECT distinct tblER.Description FROM tblER WHERE (((tblER.IDET)=47)); > > Display the results and copy paste into Excel as your master Occupations List > Do not save the query > close MSAccess > Rename back from mdb to fdb
Except, as I have pointed out before, there is no need to rename your .fdb file. Access is quite happy to open *.fdb files. It saves a couple of steps. -- Jenny M Benson 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 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