Having Trouble with a Query...

[tcv]

Hi,

I am trying to help out someone who wants to create a custom query.

Right now, he has two querys against a 2000+ database of contacts. The
first query shows everything.

The second query shows everything except those contacts that are
labelled "Inactive." The Inactive field is a check box. If the field
is checked, those entries do not show up in the second queries'
results.

I am trying to create a third query that does NOT show a record:

1. If the inactive box is checked AND
2. The e-mail field contains ANYTHING

(The E-mail field is simply a text field.)

Can anyone explain to me how to do this query?

Of course, I am happy to provide any more information.

Cheers,

Mike Whalen

 

[TPratt]

Sounds to simple, so I've probably misunderstood what you're trying to do.

Try this:

criteria for the "Inactive Box" = No (or zero)
criteria for the "Email" field (on same line as inactive box criteria) = Is
Null (or "")

 

[Rolls]

Your select criteria consists of (what you DO want to see):

[checkbox value] = -1 (No, False)

AND

[e-mail field] IS NOT Null.

 

[Rolls]

I am trying to create a third query that does NOT show a record:

1. If the inactive box is checked AND (True)
2. The e-mail field contains ANYTHING ( Is Not Null)

IOTW Select if inactive is False and if e-mail Is Null.

In the QBE window criteria line under each column type:

InactiveField "-1"
EMailField "Is Null"

Sorry I was confused by the double negative. See if this works.