469,270 Members | 1,737 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

DSum Help

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
1 1910
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.

Similar topics

2 posts views Thread by Dalan | last post: by
3 posts views Thread by Mark Reed | last post: by
4 posts views Thread by John Baker | last post: by
2 posts views Thread by GD | last post: by
1 post views Thread by Marc Aube | last post: by
6 posts views Thread by pixie | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.