[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

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

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 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 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 events

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 Alan Pereira
To: 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 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
...@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 event name which occurred

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
@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 Dennis M . Kowallek
On Wed, 9 Nov 2011 12:24:50 -, Alan Pereira alanpere...@tiscali.co.uk 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

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 a

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 alanpere...@tiscali.co.uk 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

Re: [LegacyUG] doing an event search

2011-11-09 Thread Dennis M . Kowallek
On Wed, 9 Nov 2011 16:44:52 -, Alan Pereira alanpere...@tiscali.co.uk 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

RE: [LegacyUG] doing an event search

2011-11-09 Thread Robert Austen
-Original Message- From: Alan Pereira [mailto:alanpere...@tiscali.co.uk] Sent: Wednesday, November 09, 2011 4:25 AM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] doing an event search Wow! That suggests the AND operators are not working properly. I had not come across