/NOT IN THE LIST PROBLEM in R&R SQL

[Barbara]

I^m having trouble using these two parameters in a filter. I have a field that is sometimes blank. When I use a NOT EQUAL TO/NOT IN THE LIST STATEMENT to leave out certain values using that field, any records where the field is blank are also eliminated. I can create a calculated field that flags the values I want to eliminate and use that flag in the filter, and the report works correctly.____This appears to be to be a bug in the program.____

[kfleming]

If you want to return records where a field value is empty you need to use the Is Null operator.____Kathleen__R&R Support