vb6 Null Date Problem

[lightfantastic]

I am updating a vb app which creates a report based on criteria from a form. The report is using an access database.

I need to add a facility to set the criteria for the report to date fields that are empty. In other words I need to pass the formula to include an Is Null statement.

here is what i have done so far (It comes up with error in formula)

strselform = &quot;{itemtask.taskdone} = False AND (({itemtask.year}<2001) OR (({itemtask.year}=2001) AND ({itemtask.weekno}<=10))) AND {itemtask.taskissued} Is Null&quot;

I pass this using the CR ActiveX component by SelectionFormula. It works without the {itemtask.taskissued} Is Null section....

Please help

 

[MalcolmW]

{itemtask.taskissued} Is Null
is written in Crystal syntax as
IsNull({itemtask.taskissued}) Malcolm

 

[lightfantastic]

Thanks.

It now still says error in formula and when I halt the program I get a new error:

Field Manager
Database field has not been deleted: ItemTask.TaskIssued, use count = 0

 

[dcm]

lightfantastic: Try this:

strselform = &quot;{itemtask.taskdone} = False AND {itemtask.year}<=2001) AND {itemtask.weekno}<=10 AND Isnull({itemtask.taskissued})&quot;

I think your problem was the logical OR in the middle.
David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner