Using Dsum

[scottappleford]

Hi

If you could help that would be great.


I have a main form which has two sub forms:

Main form has the following calculated fields:

1. Units in stock=[Products Subform].[Form]![UnitsInStock]-[stockcontrolsubform].[form]![netstock]

2. Units on order=[Products Subform].[Form]![UnitsOnOrder]


1st Subform - Products Subform has the following hidden calculated fields.

Units on order=Sum(nz([UnitsOrdered])-nz([UnitsReceived]))

Units In stock=Sum(nz([UnitsReceived])-nz([UnitsShrinkage]))


2nd Subform - Stock control subform has the following hidden calculated fields:

net stock=nz(DSum("QuauntityOut","IntStockControl","Transtype='issued'"))-(nz(DSum("QuauntityOut","IntStockControl","Transtype='returned'")))

The units in stock on the main form is coming up with a wild answer - maybe i am not undertsanding the Dsum correctly.

Hopefully someone can help.

thanks