Cardinal rule! On Wed, Jul 19, 2017 at 2:11 PM, Carrie Pillow <[email protected]> wrote:
> 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:[email protected]] *On > Behalf Of *Scott Hall > *Sent:* 19 July 2017 17:27 > *To:* Legacy User Group <[email protected]> > *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 <[email protected]> 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:[email protected]] *On > Behalf Of *Scott Hall > *Sent:* Tuesday, July 18, 2017 3:04 PM > *To:* [email protected] > *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 > [email protected] > To manage your subscription and unsubscribe http://legacyusers.com/ > mailman/listinfo/legacyusergroup_legacyusers.com > Archives at: > http://www.mail-archive.com/[email protected]/ > > > > -- > > LegacyUserGroup mailing list > [email protected] > To manage your subscription and unsubscribe http://legacyusers.com/ > mailman/listinfo/legacyusergroup_legacyusers.com > Archives at: > http://www.mail-archive.com/[email protected]/ > >
-- LegacyUserGroup mailing list [email protected] To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/[email protected]/
