Do a backup before working on your data in Access, it can be useful, but if you are not careful , you can corrupt your file
Regards Carrie From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of Scott Hall Sent: 19 July 2017 17:27 To: Legacy User Group <legacyusergroup@legacyusers.com> Subject: Re: [LegacyUG] Query help Donald: Thanks. I just loaded Access on my computer as it seems improving my Access skills is going to be the best way to handle the various things I want to do with my database. At 102,000 individuals and growing, there's often a lot of this type of query and consideration I'd like to do. If OK with you, I may ask some query questions from time-to-time. Scott On Tue, Jul 18, 2017 at 8:44 PM, Donald Quigley <dwquig...@cox.net<mailto:dwquig...@cox.net>> wrote: Scott, I don’t believe that you can include an address in a search string. But you can find and tag all individuals with no Burial Place and then scroll through the Search Results list looking for the blue button adjacent to the “Buried in” field on the Edit page. If its shaded out, there is no address for the Buried Place. Tag such persons and you will have created the list you want – with one caveat: If the blue button is highlited, there is likely to be a burial address – but it could be just an indication of a Burial Note/Picture/Cremated (not likely, but possible). Klunky, but it might work for you. The only sure way I can think of is to go into MS Access and write a suitable query. Easy to say, but not if you don’t know Access. Donald Quigley Escondido, CA Quigley Doyle Family Tree<https://donquigley.net/> From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com<mailto:legacyusergroup-boun...@legacyusers.com>] On Behalf Of Scott Hall Sent: Tuesday, July 18, 2017 3:04 PM To: LegacyUserGroup@legacyusers.com<mailto:LegacyUserGroup@legacyusers.com> Subject: [LegacyUG] Query help I want to build a search query to identify all users with data in the burial place field but no attached burial address. Can anyone assist? I cannot figure out how to get attached addresses into the search string. Thanks, Scott -- LegacyUserGroup mailing list LegacyUserGroup@legacyusers.com<mailto:LegacyUserGroup@legacyusers.com> To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/legacyusergroup@legacyusers.com/
-- LegacyUserGroup mailing list LegacyUserGroup@legacyusers.com To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/legacyusergroup@legacyusers.com/
