on 09-26-2008 8:51 PM
Greeting,
I try to filter a field by using selection formula. The field contains value: 'Y', 'N' and null. When I set the field1<> Y or not start with Y, it will filter off those record with null value. How to filter off 'Y' and keep the null value data?
go to file
report options
check null values boxes
formula
if isnull(field) or if <> 'Y' then true
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.