* Editing a Query

[oldtimer47]

Dear All

I'm trying to write a slightly more complicated query and I don't know how to edit the line.  The 'selector boxes' do a very good job of writing a single condition but I don't know how to add a second condition to that same line.

What I am trying to do is list all Sources that begin with Bir (In my sources these are Birth Certificates) but which do not have any associated Text.  I am trying to get the following line into the Query

Add if %SOUR.TITL% begins with 'Bir' and isEmpty(%SOUR.TEXT%)

The first part works fine but I can't add the extra bit. For all I know I may have invalid code but I'm trying to learn by writing these queries that help me analyse my data.

Any help or pointers gratefully received

Thanks, Peter

ID:4126

[PeterR]

Peter,
What I would do is have as first filter:

Add if %SOUR.TITL% begins with 'Bir'

Then add a 2nd filter thus:

Exclude unless %SOUR.TEXT% is null

This seems to work for me. Or your 2nd filter could be:

Exclude unless =IsEmpty(%SOUR.TEXT%) is true

which also works.

[oldtimer47]

Brilliant !

I never thought of them as filters - I was *assuming* that once they had been selected that was it. I have now extended your suggestion so that 3 initial filters select 'Bir' 'Mar' and 'Dea' and the last filter is Exclude unless %SOUR.TEXT% is null.

I then get a nice list of records where I need to find the missing information.

Thanks again
Peter