NULL FIELDS

[jobillborf]

Hi, I am trying to do a report where the following will not appear in a PROBLEM FIELD "WFD" "WDUP" and "VOID". I also want the null records to appear.

When I do Not( {PROBLEM} like["WFD", "WDUP", "VOID"] THE NULL VALUES DO NOT APPEAR.

Please Help

thanks

 

[dcm]

jobilborf: You will also need to test for Isnull({Problem}) as in:

( Isnull({Problem})=true or Not( {PROBLEM} like["WFD", "WDUP", "VOID"] )

Hope this helps David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[jobillborf]

thanks dcm, could you explain to me what the formula is actually doing. thank you for your help

 

[dcm]

jobillborf: The first part of the formula:

Idnull(Problem) = true

is checking for any record where Problem has a null value

The second part is your check for Problem not matching a defined list of values

The combination of the 2 gives a Boolean True/False reply which you can use to select data i.e. if this field were called @valid_record then you could include in your select expert the section

@valid_record id equal to true

Hope this helps David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[dcm]

typo!

@valid_record id equal to true

should read

@valid_record is equal to true David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner