mabino79201

have Sub Form containts product ID & Qty

Want total of Qty which product selected on main form.
 
is this solve the

=DSum([Qty],[tblInventoryTransaction]![ProductCode]=[ProductCode])
 
=[tblInventoryTransactionSubForm].[Form]![Text83]

getting error retrieving value from sum form in main form
 
a është kjo zgjidhje

=DSum ([Sasia],[tblInventoryTransaction]![Kodi i produktit]=[Kodi i produktit])
Expr1: DSum ("[Sasiah]-[Sasia]","Baza","[Barkode]='" & [Barkodi] & "'")
 
is this solve the

=DSum([Qty],[tblInventoryTransaction]![ProductCode]=[ProductCode])
Expr1: DSum("[Qty]","tblInventoryTransaction","[ProductCode]='" & [ProductCode] & "'")
 

Users who are viewing this thread

Back
Top Bottom