Report not summing correct for 1 field only

[Lhuffst]

I have a report that is based on a query.
the report has

Group: DateAdded: No fields and no header but selected with totals
Detail:(fields)
DateAdded
SubmittedBy
Mt_NumPassed
Mt_PercentPassed
MP_NoMtrprocessed

DateAdded Footer: (fields)
Month totals (label)
sum(Mt_NumPassed)
sum(Mt_PercentPassed)
sum(MP_NoMtrProcessed)
...

Report Footer
Grand total sums here

Data for the timeframe (for problem column only)
August 2016        1
September 2016 
October 2016      1.1e+07

I used the sum feature under grouping & totals. All columns add correctly except for MP_NoMtrProcessed. The values I'm getting are 1.1E+07
Normally I would think that the field size is too small but when I check the query, there is only 1 value and the rest are blank.
I tried to use the nz but then the sum feature didn't work.

I am at a loss as to what I should check next.
Any suggestions and help are always appreciated.
lhuffst

 

[LaurieHamlin]

Try Nz on the field value so you're summing a Nz value.
I hope that helps.