"0" in a sum calculation not showing up?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following code, but "0" is not showing up (it's blank). Any ideas
why? (By the way, "Allocated Case Volume" is a number.")

=Sum(IIf([Product Type]=Forms![Allied or Monster]!ProductTypeV And
[Transition Complete YN]=True,[Allocated Case Volume],Null))

-Adam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF syntax problem... 1
"#Num!" Error display as "-"? 1
Left Join Confusion 4
Passing data from a form to report field 4
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Calculate a sum of subreports in main report 1
Numbers showing Up Centered in Cell ? 1
# Error when no data 4

Back
Top