TMG-L Archives

Archiver > TMG > 2008-06 > 1213723066


From: "Jim Byram" <>
Subject: Re: [TMG] LOP report question v7.0
Date: Tue, 17 Jun 2008 13:17:46 -0400
References: <001c01c8d030$b8dda440$0301a8c0@BJLaptop>
In-Reply-To: <001c01c8d030$b8dda440$0301a8c0@BJLaptop>


Barbara Heard wrote:

> It's probably obvious, but what am I doing wrong?
> I want an LOP of all people who had any event between 1/1/1897 and
> 12/31/1910 in San Francisco County.
> My report filter is:
> any event date comes after 12/31/1896 and
> any event date comes before 1/1/1911 and
> any event COUNTY equals San Francisco

You realize that since this is a LOP, you can get a result based on three
different tags for the person? Nothing says the three conditions apply to
one tag, only to one person.

You probably want to use...

List of Events
filter
Date > Comes after 31 DEC 1896 AND
Date < Come before 1 JAN 1911 AND
County = SAN FRANCISCO END

Then you would get only events that met all three conditions.

The date would depend on your date format.
The county field would have to contain exactly "SAN FRANCISCO". Otherwise
you should use the 'contains' operator.

I tested this and it worked perfectly.

Jim


This thread: