Inner Join returns no records, how to be used in a calc..

[Cangioli]

Sorry, its difficult to express my dilema in the Subject. What I'm doing is
using an inner join of 2 tables to compare inquiry ids. The ids are unique
to each record, and I am comparing the prior day's inventory to today's, and
using a Count function to display the amount of carryover. I use that result
to then calculate incoming and output values (in separate queries). My
problem is that when the carryover = 0, my resulting queries will not
calculate. Is there a way to either default my Count to 0 if no records
match, or possibly make some type of Iif statement in my incoming and output
calculations? Any help is appreciated. Thanks

 

[Golfinray]

In a new row in your query, try
Whatever name you want:IIF([your field]is null,"0",[your field])

 

[Cangioli]

Thanks. I'll give that a swing.

In a new row in your query, try
Whatever name you want:IIF([your field]is null,"0",[your field])

Sorry, its difficult to express my dilema in the Subject. What I'm doing is
using an inner join of 2 tables to compare inquiry ids. The ids are unique
to each record, and I am comparing the prior day's inventory to today's, and
using a Count function to display the amount of carryover. I use that result
to then calculate incoming and output values (in separate queries). My
problem is that when the carryover = 0, my resulting queries will not
calculate. Is there a way to either default my Count to 0 if no records
match, or possibly make some type of Iif statement in my incoming and output
calculations? Any help is appreciated. Thanks