DSUM Function (Access Reports)

[mouseman]

I have an Access reports that totals Order Qty. I have a Grand total for the report. Also under the grand total i have a total EX Quantity and Mi Quantity I get those qauntities using the Dsum Function. Now here is my question i would like to minus EX and Mi Quantity from the grand total. I used this formula =Sum([OQTY])-DSum("[OQTY]","My Domain","[OTYP]=EX'&quot-DSum("[OQTY]","My domain","[OTYP]=MI'&quot. This formula does work, but sometimes it does not. It does not work if one quantity is found and the other quantity is not found. When this happens it leaves an empty space. When both quantities are found, it does it correctly. So is there way, that the formula will work all the time. Thanks you for your help

 

[janetap]

I believe you have Null value issue in your formula
May be this will help.

=Sum(Nz([OQTY]))-DSum("Nz([OQTY])","My Domain","Nz([OTYP])=EX'&quot-DSum("Nz([OQTY])","My domain","Nz([OTYP])=MI'&quot.