By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,663 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,663 IT Pros & Developers. It's quick & easy.

DSum Help

P: n/a
Hi All

i am trying to calculate Quantity on hand in a unbound textbox in a
form [FrmMainListing] with a subform [FrmSubListing]

QonHand=Qreceived - TotalQSold
TotalQsold=QsoldOnEbay+QsoldThruOtherChannels

here is my expression:

= [Ir0n] - ( ( DSum ( "[Sq0]", "tblSold","SlistingID" =
"[FrmSubListing].Form![ListingID] ) + (DSum
("[ocQ0N]","TblOtherQandL","oItemID" =
"[FrmMainListing}.Form![iItemID]))

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ok i got 3 improved but still not working versions of the expression

=[Ir0n]-((DSum(nz("[Sq0]",0),"tblSold","SlistingID"=nz("[FrmSubListing].Form![ListingID]
",0)))-(DSum(nz("[ocQ0N]",0),"TblOtherQandL","oItemID"=nz("[FrmMainListing].Form![iItemID]",0))))
=[Ir0n]-((DSum(nz("[Sq0]",0),"tblSold","SlistingID"="[FrmSubListing].Form![ListingID]
"))-(DSum(nz("[ocQ0N]",0),"TblOtherQandL","oItemID"="[FrmMainListing].Form![iItemID]")))

=[Ir0n]-((DSum("[Sq0]","tblSold","SlistingID"="[FrmSubListing].Form![ListingID]
"))-(DSum("[ocQ0N]","TblOtherQandL","oItemID"="[FrmMainListing].Form![iItemID]")))

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.