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

  • Thread starter Thread starter Cangioli
  • Start date Start date
C

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
 
In a new row in your query, try
Whatever name you want:IIF([your field]is null,"0",[your field])
 
Thanks. I'll give that a swing.

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

Cangioli said:
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
Click to expand...
Click to expand...
 
Back
Top