NOT formula 1

[Schnappa]

Hi all

I am in the process of producing a draft report of clients and their addresses - pretty simple stuff really, however I have come accross a problem using the select expert. I have a report that brings back numerous pieces of information about clients within the database, one being the 'department number'. I have the following selection criterea in my embryonic select expert field

{Client.ClientType} = "Prime" and
{Client.MemberFlag} and
{ClientContact.MailAddrValid} and
{@Client_Type} <> "Business" and
{@Client_Type} <> "Personal II" and
not {Client.Deceased} and
isnull({Client.AddName}) = false

The problem is the @client_Type selctions above. This calculation looks at the department number and groups them into three type, being Business, Personal and Personal II. I have had to produce this calculation because the simple process of using this criterea

not ({Client.Department} in [888.00, 444.00])

** 888 = Business
** 444 = Personal II

This causes me to lose not only the clients with these department numbers (OK), but also all the clients with NULL department numbers (not OK). On the fly, I thought up the @Client_Type, but now I want to work it out properly. HOw can I keep my NULL valued clients?

I am using CR 10 against and Access database.

Many thanks to all...

Gerard

 

[Katy44]

try using:

(isNull({Client.Department}) or not ({Client.Department} in [888.00, 444.00]))

instead of those two statements using the @Client_Type formula. The order is important - the check for null must be first.

Hope this works, let me know if it doesn't