Null value issue

[#1]

Hi

I have a count of values in list box is 20 but it is showing count as 21 in header. i have a Data with null but I compressed in script using where condition. even though it is  showing as 21 instead of 20.when I count manually there are only 20.

Please help on this.

Thanks

[#2]

Hi

Attached Image is with null in Data. I filtered in Scripting using where condition like

where key>0;

but still in list box it is showing

[sunny_talwar]

Try this where statement:

Where If(Len(Trim(key)) > 0;

[swuehl]

Sorry I can't see your attached image.

If you want to filter NULL in your where clause, follow Sunny's suggestion, though I still havent't seen something that points to a NULL issue in the information you've posted so far (which you can read as: please post more details)

[#5]

Thanks sunny and swuehl

its perfect now

Problem is because of Duplicates