I need a BLANK return not a zero

[Zeppelin]

I want to return a blank value to feed a report. This statement works but when I run the querie of course it stops and asks what value I want for the empty [] so I have to press enter. There is no other output to this other then the report so I dont have to worry about further calculations from the results of this function. I just want a blank if the Begin to case completed is zippo....



IIf([Begin_to_Case_Completed_Date]=0,[],[Begin_to_Case_Completed_Date])/60

 

[Mile-O]

Instead of [], put Null.

 

[Zeppelin]

Well DUH that worked. <bangs head on table>

Thanks Mike!

 

[Mile-O]

Mike?

 

[Zeppelin]

Mile-o-phile ,

After banging my head on the table I was seeing crosseyed.