isnull formula

[fhurmuzlu]

I have two fields

Division and incidents

Divison incidents
northeast 20
southeast 30
(Blank) 10

what is the formula if Divison shows blank or null but there is incidents value .I want do not show the incidents value if division is no value o, blank or null.

 

[jmd0252]

possibly something like this:
Not IsNull({division})
in your selection statement.

 

[hilfy]

Actually, if there's a possibility that there may be a value that is one or more spaces in the field instead of null, you'll do this:

Not IsNull({division}) and Ltrim(Rtrim({division})) <> ""

NOTE: When working with Nulls, you ALWAYS check for Null FIRST!

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.