Can I alter my expression so I don't have to manually enter zeros when either field 1 or 2 are blank

[vit2016]

Is it possible to alter my expression so I don't have to manually enter zeros when either field 1 or field 2 are blank?
For example, in Field 1 there is nothing. In Field 2, there is 1. In Field 3, there is 650. The total reads nothing. If I manually enter a zero into Field 1, the total will read 650.
Expression:
Total: IIf([Table 1]![Field 1]+[Table 1]![Field 2]=0,Null,[Table 1]![Field 3]/([Table 1]![Field 1]+[Table 2]![Field 2]))


I've tried making these changes, but it didn't work:

Total: IIf (Nz([Table 1]![Field 1], 0)+Nz([Table 1]![Field 2], 0)=0,Null,[Table 1]![Field 3]/([Table 1]![Field 1]+[Table 1]![Field 2]))



I am not very knowledgeable with access, so I don't know if this is possible. Thank you for your help.

[ranman256]

convert Nulls to Zero:

nz([Table 1])+nz([Table 2])
but it will NEVER be null, so you don't need the IIF.

[vit2016]

Thank you for your help. Are you referring to the second part or the first?

Total: IIf (Nz([Table 1]![Field 1], 0)+Nz([Table 1]![Field 2], 0)=0,Null,[Table 1]![Field 3]/([Table 1]![Field 1]+[Table 1]![Field 2]))

[ranman256]

the entire IIF statement. If you NZ all your fields , no IIf is needed just:
=NZ(Table 1]![Field 3]/(NZ([Table 1]![Field 1])+NZ([Table 1]![Field 2])))

[vit2016]

the entire IIF statement. If you NZ all your fields , no IIf is needed just:
=NZ(Table 1]![Field 3]/(NZ([Table 1]![Field 1])+NZ([Table 1]![Field 2])))

If I do that, I receive #Num! and #Div/0! errors

Total: Nz([Table 1]![Field 3],0)/Nz([Table 1]![Field 1],0)+Nz([Table 1]![Field 2],0)

[NoellaG]

Try
IIf (Nz([Table 1]![Field 1], 0)+Nz([Table 1]![Field 2], 0)=0,Null,[Table 1]![Field 3]/(NZ([Table 1]![Field 1],0)+NZ([Table 1]![Field 2],0)))

[vit2016]

The same problem happened

If I do that, I receive #Num! and #Div/0! errors

Total: Nz([Table 1]![Field 3],0)/Nz([Table 1]![Field 1],0)+Nz([Table 1]![Field 2],0)

Edit: Quote added

[orange]

How about describing WHAT you are trying to do, rather than how you have done something that isn't working?
Experienced people have offered suggestions and

The same problem happened

so I think we need to hear the requirement clearly in simple terms, and then see if some options follow.

[vit2016]

I explain in my earlier posts.

Is it possible to alter my expression so I don't have to manually enter zeros when either field 1 or field 2 are blank?
For example, in Field 1 there is nothing. In Field 2, there is 1. In Field 3, there is 650. The total reads nothing. If I manually enter a zero into Field 1, the total will read 650.
Expression:
Total: IIf([Table 1]![Field 1]+[Table 1]![Field 2]=0,Null,[Table 1]![Field 3]/([Table 1]![Field 1]+[Table 2]![Field 2]))


I've tried making these changes, but it didn't work:

Total: IIf (Nz([Table 1]![Field 1], 0)+Nz([Table 1]![Field 2], 0)=0,Null,[Table 1]![Field 3]/([Table 1]![Field 1]+[Table 1]![Field 2]))

I am not very knowledgeable with access, so I don't know if this is possible. Thank you for your help.

---

If I do that, I receive #Num! and #Div/0! errors

Total: Nz([Table 1]![Field 3],0)/Nz([Table 1]![Field 1],0)+Nz([Table 1]![Field 2],0)

[vit2016]

How about describing WHAT you are trying to do, rather than how you have done something that isn't working?
Experienced people have offered suggestions and
so I think we need to hear the requirement clearly in simple terms, and then see if some options follow.

I appreciate the help. I now added the quote in my response after a bit of a struggle. I am not good at using message boards. I did not mean to post twice (this and above). Please don't misunderstand. Thank you.

[orange]

Sorry, but your first post only shows us something that you have done

Total: IIf([Table 1]![Field 1]+[Table 1]![Field 2]=0,Null,[Table 1]![Field 3]/([Table 1]![Field 1]+[Table 2]![Field 2]))

WHAT is it - in plain simple English - you are trying to solve using that expression?

What are table1 and table2?

Since you are getting

If I do that, I receive #Num! and #Div/0! errors

,
there is an error somewhere in your table(s), your expression.
Division by 0 is an absolute No-No! which indicates ([Table 1]![Field 1]+[Table 2]![Field 2]) is rendered as 0.??????

We need to understand the problem you are trying to solve.
Good luck.

[vit2016]

Sorry, but your first post only shows us something that you have done


WHAT is it - in plain simple English - you are trying to solve using that expression?

What are table1 and table2?

Since you are getting
,
there is an error somewhere in your table(s), your expression.

We need to understand the problem you are trying to solve.
Good luck.

I am sorry I thought by what I am trying to achieve you are referring to this. Honest miscommunication

"Is it possible to alter my expression so I don't have to manually enter zeros when either field 1 or field 2 are blank?"

I want to find cost per use. Field 1 and Field 2 are the item uses. Field 3 is the cost. Some items are not used, and some items don't have a cost. Thanks for your help. Thank you

[orange]

So is Table2 a mistake in your expression in post 1?

Working with the expression from NoellaG:
IIf (Nz([Table 1]![Field 1], 0)+Nz([Table 1]![Field 2], 0)=0,Null,[Table 1]![Field 3]/(NZ([Table 1]![Field 1],0)+NZ([Table 1]![Field 2],0)))

If there is only table1, then you do not need the reference to Table1. And you wouldn't refer to a field in a table with "!", so

IIf (Nz([Field 1], 0)+Nz([Field 2], 0)=0,Null,[Field 3]/(NZ([Field 1],0)+NZ([Field 2],0))) and I would add another pair of brackets

TRY:
Total: IIf (Nz([Field 1], 0)+Nz([Field 2], 0)=0,Null,([Field 3]/(NZ([Field 1],0)+NZ([Field 2],0))))

But what are the datatypes of [Field 1], [field 2] and [field 3]?

Can you take a Printscreen of your table and its values? Post as a jpg