NULL values in ACCESS reports? -


i created simple report has 5 columns (companyname, bought, sold, returned, total) looks like.

companyname bought sold returned total

with exception of company name, every value number. created simple queries bought, sold , returned. total used arithmetic in main query (basically sum of bought, sold, returned (returned negative)). problem came across companies, of columns (bought,sold,returned) null since ex: don't have returned when run report, doesn't show me value total. unless have values in three(bought sold , returned) - nothing gets displayed in total. don't want display zeros in report because clustered, there way me convert null 0 when calculation , hide report?


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

c++ - Can not find the "fiostream.h" file -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -