Re: [LegacyUG] doing an event search

2011-11-10 Thread Paula Ryburn
van Weller Williams From: Mark Wilby To: LegacyUserGroup@LegacyUsers.com Sent: Wed, November 9, 2011 3:01:46 AM Subject: [LegacyUG] doing an event search Hi folks, What I am trying to do is search for a single event that contains a specific date AND description.

RE: [LegacyUG] doing an event search

2011-11-09 Thread Robert Austen
Event Description' is different from 'Notes' contained in the Event. Hope I was able to explain it properly. Bob -Original Message- From: Alan Pereira [mailto:alanpere...@tiscali.co.uk] Sent: Wednesday, November 09, 2011 4:25 AM To: LegacyUserGroup@LegacyUsers.com Subjec

Re: [LegacyUG] doing an event search

2011-11-09 Thread Dennis M . Kowallek
On Wed, 9 Nov 2011 16:44:52 -, "Alan Pereira" wrote: >Even breaking the query down with advanced tagging will end up with the same >results. You can do it with Access or LTools. Using Jenny's example, the query would look something like ... SELECT tblIR.IDIR AS RIN FROM (tblET INNER JOIN t

RE: [LegacyUG] doing an event search

2011-11-09 Thread Alan Pereira
@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search On Wed, 9 Nov 2011 12:24:50 -, "Alan Pereira" wrote: >That suggests the "AND" operators are not working properly. No, it is working properly ... just not the way you expect. In English, Jenny's query looks

Re: [LegacyUG] doing an event search

2011-11-09 Thread Jenny M Benson
On 09/11/2011 12:36, Alan Pereira wrote: > If you take the search results and tag them say with tag 1, then use > tag1 as the first criteria and one of your criteria as the second > condition, does that change the result. Because you can only search on Individuals or Marriages, you can't look for

Re: [LegacyUG] doing an event search

2011-11-09 Thread Dennis M . Kowallek
On Wed, 9 Nov 2011 12:24:50 -, "Alan Pereira" wrote: >That suggests the "AND" operators are not working properly. No, it is working properly ... just not the way you expect. In English, Jenny's query looks something like... Find all individuals with an event where EventName equals "England

RE: [LegacyUG] doing an event search

2011-11-09 Thread Alan Pereira
@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Yes Alan But you get a mixture of both search criteria as well. mark From: Alan Pereira [mailto:alanpere...@tiscali.co.uk] Sent: 09 November 2011 11:53 To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search

RE: [LegacyUG] doing an event search

2011-11-09 Thread Mark Wilby
Yes Alan But you get a mixture of both search criteria as well. mark From: Alan Pereira [mailto:alanpere...@tiscali.co.uk] Sent: 09 November 2011 11:53 To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Ron, Mark I am struggling to understand the problem

RE: [LegacyUG] doing an event search

2011-11-09 Thread Alan Pereira
[mailto:ge...@cedarbank.me.uk] Sent: 09 November 2011 12:14 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search On 09/11/2011 11:53, Alan Pereira wrote: > I am struggling to understand the problem. In search you can search > for an individual who has a specific

Re: [LegacyUG] doing an event search

2011-11-09 Thread Jenny M Benson
On 09/11/2011 11:53, Alan Pereira wrote: > I am struggling to understand the problem. In search you can search for > an individual who has a specific event name which occurred on a specific > date that has a specific description. Not quite! I have individuals who all appeared in the 1911 Census.

RE: [LegacyUG] doing an event search

2011-11-09 Thread Alan Pereira
: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search Mark, Ah, that is the bit which I did not get! No, you cannot search for a single Event. All Detailed searches are for Individuals or Marriages. Ron Ferguson http://www.fergys.co.uk/ From: Mark Wilby

Re: [LegacyUG] doing an event search

2011-11-09 Thread Ron Ferguson
: [LegacyUG] doing an event search Hi Ron, Yes you understand the problem well. I had another look at the search page and tried to think a bit deeper. The primary condition does say “look for whom”, so maybe you can only search for an individual who has criteria 1 and/or criteria 2. What I need

Re: [LegacyUG] doing an event search

2011-11-09 Thread Mike Fry
On 2011/11/09 11:01, Mark Wilby wrote: > What I am trying to do is search for a single event that contains a specific > date AND description. But when I search, for example, an event date of 1841 > and > an event description of “not looked for”, the search returns all 1841 events > and > all eve

Re: [LegacyUG] doing an event search

2011-11-09 Thread Jenny M Benson
On 09/11/2011 10:26, Mark Wilby wrote: > Yes you understand the problem well. I had another look at the search > page and tried to think a bit deeper. The primary condition does say > “look for whom”, so maybe you can only search for an individual who has > criteria 1 and/or criteria 2. What I

RE: [LegacyUG] doing an event search

2011-11-09 Thread Mark Wilby
with these criteria. Can this be done? I’m beginning to think not. Regards Mark From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 09 November 2011 10:04 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] doing an event search Mark, My apologies, after posting I

Re: [LegacyUG] doing an event search

2011-11-09 Thread Ron Ferguson
, November 09, 2011 9:01 AM To: LegacyUserGroup@LegacyUsers.com Subject: [LegacyUG] doing an event search Hi folks, What I am trying to do is search for a single event that contains a specific date AND description. But when I search, for example, an event date of 1841 and an event description of

Re: [LegacyUG] doing an event search

2011-11-09 Thread Ron Ferguson
@LegacyUsers.com Subject: [LegacyUG] doing an event search Hi folks, What I am trying to do is search for a single event that contains a specific date AND description. But when I search, for example, an event date of 1841 and an event description of “not looked for”, the search returns all 1841 events and

[LegacyUG] doing an event search

2011-11-09 Thread Mark Wilby
Hi folks, What I am trying to do is search for a single event that contains a specific date AND description. But when I search, for example, an event date of 1841 and an event description of "not looked for", the search returns all 1841 events and all events with the description of "not looked f