Parameter Query - IIF or Nz not working

[weilerdo]

Hey Everyone, This one is driving me crazy. I have a query that is based on 2 tables. I need the result of the query to be the sum of hours or if no hours then I need a 0. I have searched and tried just about every IIF and NZ function I could find and when I add them I get no results. Which then gives me #error on my report. I have attached a pic of my query and results. I would be forever thankful if someone could help we with this as I have been struggling for a week on this issue and my boss is getting on my case about why this is not done.

Thank you in advance for all your help with this.

 

[RV]

Put the Nz function around the Sum Funxtion and see if that works:

Nz(Sum(blabla),0)

RV

 

[weilerdo]

Thanks RV I was able to make an Expression using your function and it worked.

Thanks again your a life saver