I am created a report and I’d like to filter on a y Y YES Yes or yes in a given field. If any of these are true then include the record in the report. This works fine. Now turn the test in reverse… if any of those y Y YES Yes or yes are in the field exclude the record from the report. In my test case I have, the field has y Y YES Yes yes or nothing (a blank field). When I create a criteria of <>‘y’ and include all the combinations of yeses I should get all the blanks to be in the report… doesn’t happen, nothing is in the report. This is a split database. This is on a Windows platform: Version: 5.3.3.2 (x64) Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Layout Engine: new; Locale: en-US (en_US); Calc: group… I updated to Version: 5.3.4.2 (x64)
Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Layout Engine: new; Locale: en-US (en_US); Calc: group
and the same results.
Puzzled.
You seem to try to compare a NULL with a value. That doesn’t work: