I am using a query in Access to feed a pivot table. I am using iif() to do several conditional sums across 5 columns based on 1 column of values. The first 3 added up fine and work great in my pivot table. But my last 2 appear left aligned in my query (the first 3 are right aligned)and then do not show up at all in my pivot table. I tried using clng(), but still nothing. When I am on those 2 columns, there are no values for me to select in the "Format" section of the properties in Access either. Again the other 3 are working just fine. I cannot figure it out since I am summing on the same column based on different conditions. What is happening?