Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report output different from Query ouput

Status
Not open for further replies.

jstew

MIS
Apr 12, 2002
51
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top