In an access I have a query that uses the values from several other sum queries. It is an inventory query which shows such things as items in stock(total delivered – total sent out) and items on order (total ordered – total delivered). Using the join properties the query will show results for each item even if there are no results for it in some of the sum fields. The problem is that with these fields with no results (null valuse) no value is shown in the expression. For example: 20 desks have been ordered but none have yet been delivered (a null value for total delivered). The on order expression shows nothing rather than 20 as it should. I am sure there must be some way to replace all null values in an expression with zeros.
Thanks for any help.
Mark