I have a query that has a field with an expression that checks if items are past due. I have it working correctly, but now when I run a report that calls this query it is printing zero's in fields that have null values. What's weird to me is that in the query results it doesn't list zero's for these fields, just blank which is what I want. It really wouldn't be a big deal, but it is affecting my expression and causing it to output wrong results in the report. The two fields that it is happening to are both numeric fields (if that makes a difference). Also the tables the query is running against are ODBC linked tables, so changing table structure is out of the question.
Thanks for all the help.
jstew
Thanks for all the help.
jstew