Blank date time field formula problem

[Bennie47250]

Crystal 7.0 using a SQL 7.0 table linked in Access 97

Trying to write a formula that checks this field to see if it contains a value. If NO value is found do this, if a value is found do that. I can’t seem to find the proper way of checking this field for a NULL. Any tips would be appreciated.

Thanks
Bennie

 

[mbarron]

Depending on your set-up one of the following should work:

if isnull(field} the do this else do that
or
if {field}=0 then do this else do that
or
if {field}="" then do this else do that Mike

 

[Bennie47250]

Thanks Mike, Got it to work. Appreciate your help.