Counting Nulls

[Eagle0107]

I am trying to create a report and have a small issue counting NULLs.

My record selection formula is:

{TABLE.DateCreated} >= {?StartDate} and {TABLE.DateCreated} <= {?EndDate} AND
IsNull({TABLE.Field}) OR
{TABLE.Field} = ''

This gives me all record between the dates with either a NULL or a blank in the field. The issue is that I also have a total count on Group. It gives me the total for the records with blanks but returns a 0 for total with nulls even though there are some 25 or so records.

My cout formula is:

Count ({TABLE.Field}, {TABLE.Field})

Any guidance would be greatly appriciated..

 

[lbass]

You could just count any field that cannot be null, or you could go to file->report options and check "convert nulls to default values", or you could create a formula like this:

if isnull({table.field}) then
"" else
{table.field}

Then insert a count on this formula.

-LB

 

[Eagle0107]

Dah... Covert Nulls to default values....

Thanks just had a blonde moment..... and I am not even blonde....

 

[lbass]

But I am.

-LB

 

[kray4660]

I am not blond either, but I am old enough to start claiming senior moments