DSum("[Quantity]","Order details","[ProdID] = " & Me![ProdId])
minus the below
DSum("[Quantity]","Stock ordered","[ProdID] = " & Me![ProdId])
Using an update query to return the differencial values!
In other words what I have bought minus what I have sold!
The Id key is giving a handfull or problems (ie key violations!
Thanks in advance !
minus the below
DSum("[Quantity]","Stock ordered","[ProdID] = " & Me![ProdId])
Using an update query to return the differencial values!
In other words what I have bought minus what I have sold!
The Id key is giving a handfull or problems (ie key violations!
Thanks in advance !