TMG-L Archives

Archiver > TMG > 2002-01 > 1009913989


From: Bob Velke <>
Subject: Re: [TMG] Filter problem with Any Event Group Date
Date: Tue, 01 Jan 2002 14:39:49 -0500
In-Reply-To: <5OTtrhC9agM8EwvS@hotair.demon.co.uk>


Tony said:

>I would like to identify everyone in my dataset who has any tag with a
>date before 1791, say. Nothing to do with the 1901 Census for England and
>Wales, of course :)
>
>In a List of People report, the filter "Any Event Group Date Year is less
>than 1791" does include the subset I require, but it also includes
>everyone with any undated tag. Variations on the theme, like "Any Event
>Group Date (Wide) Comes Before 01 Jan 1791", have the same problem.
>
>It's no good excluding all people with "Any Event Group Date (Wide) Is
>Empty", because someone with 2 tags, one undated and one pre-1791, will
>erroneously be excluded.
>
>Count me as a seasoned filter-writer, but this one has me beat. Any solution?

The List of People report can filter for _people_ who have two
characteristics but if want people who have a single _event_ which has two
characteristics then you'll do better with a List of Events report. You'll
probably want to sort the output by the Principal ID (or output the results
to Excel, etc., where you can post-process the list to get a unique list of
people) .

Hope this helps.

-Bob

This thread: