Query Is Null And >0 (Zero)

[solsearcher]

Just trying to run a basic query where results include Blank entries and values greater than zero. Therefor just excluding the 0 (Zero) entry.



I'm a newbie, and have tried variations of what I thought should work but they haven't.

Thanks in advance!!!!

[RayMilhon]

If you want to include both in the criteria for that field you should but Is Null or >0

[solsearcher]

I have already tried this. The blank entries are excluded. The results are only values above zero.

[RayMilhon]

Is it possible the blank entries are empty not null What's the data type of the field. Also are there any joins in the query?