On Mon, 27 Jun 2005 12:16:08 -0700, Sven-Ove Westberg <[EMAIL PROTECTED]> wrote:
>I try to get a list of all used source details. But I can not find a way to >do it in Legacy. So I ended up copy the column in Access to Excel and there >sort and make it unique. Is there a better way to do it? Probably not. Although you shouldn't have to copy to Excel to do what you want. You should be able to do it entirely in Access. Something like... SELECT DISTINCT tblSX.SrcDetail FROM tblSX ORDER BY tblSX.SrcDetail; >I would also like to get a list where a source detail is used how do I do that? Again, you will probably need to use Access. >I can do a search and replace on source detail but I can not use in the >search why? I would guess that not enough people have asked for it. I would use it. -- Dennis M. Kowallek [EMAIL PROTECTED] ****************** Legacy User Group Etiquette 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/ To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
