I run a query between two dates. Ja

[DianaStewart]

I run a query between two dates. Jan to Aug, but for some reason my Variable for Sept, Oct, Nov and Dec contain a value. Is there a way to indicate: if the variable is Null then assign it value 0 else variable

 

[IdoMillet]

The situation is not very clear, but you can always create a formula such as:
----------------------------------------------
IF IsNull({something}) THEN 0 ELSE {something}
----------------------------------------------

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com