Report output different from Query ouput

[jstew]

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

 

[SgtJarrow]

It does make a difference that the fields are numeric....it is not possible store a Null value in a numeric field....even if the field is blank, in a calculation the field is treated as 0....but without more explanation, it is not clear as to why a zero should affect your math... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCSA, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com