Skip to Content
0
Former Member
Feb 27, 2009 at 07:37 PM

Cannot use Is Null in record selection

28 Views

I cannot use Is Null in a record selection expert. I use the same wording in excel and SQL QA with no issues.

I need all records that are not '5 - Project' including Nulls. Once I put the criteria of '5 - Project' it excludes the null records.

{@dtCompleted} = {?Completed_Date_ Range} and

{TASKS.TYPE} = "Information Technology" and

{TASKS.PRIORITY} <>'5 - Project'

This does not give me the nulls for the Priority field.

The one I use in QA or in Excel is

{@dtCompleted} = {?Completed_Date_ Range} and

{TASKS.TYPE} = "Information Technology" and

({TASKS.PRIORITY} <>'5 - Project' or {TASKS.PRIORITY} is null)

This gives me the "The ) is missing" error. Help!