I want to select anything where a value is null, for an incident enter 1

[jschill2628]

I want to select anything where a value is null, for an incident entered in the system before today at noon. I am then going to burst the report out everyday.

 

[IanWaterman]

In select expert just enter

isnull(yourfield)

if multiple fields

(isnull(yourfield1) or isnull(yourfield2) or isnull(yourfield3)
or......)

Ian

 

[lbass]

Isnull({table.field}) and
{table.datetime} = currentdate and
{table.datetime} < datetime(currentdate,time(12,0,0))

-LB