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

DSum Assistance

P: n/a
I'm using Access 97 and need some assistance in sorting out a proper
DSum expression. It relates to a subform (sfrmCost) from which I'm
wanting to extract the grand total of any and all data rows that have
the same primary IDReference, and have it post as an accumulative sum
in one text box (TotalCost) on the main form (frmMain). There are
actually three columns across in each row which contain number values
and I have been able to only obtain the total of one row (SubTotal)
with the same IDRef number. It seems that this is a job for DSum to
handle when there are multiple occurrences of the same IDRef. Any
assistance provided will be appreciated. Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
you might try using an intermediary query

TotalCost=Nz(DSum("SubTotal","qryTotal","IDRef=For ms!frmMain!frmSubForm!IDRe
f"),0)

"Rolan" <ba***@safe-mail.net> wrote in message
news:18*************************@posting.google.co m...
I'm using Access 97 and need some assistance in sorting out a proper
DSum expression. It relates to a subform (sfrmCost) from which I'm
wanting to extract the grand total of any and all data rows that have
the same primary IDReference, and have it post as an accumulative sum
in one text box (TotalCost) on the main form (frmMain). There are
actually three columns across in each row which contain number values
and I have been able to only obtain the total of one row (SubTotal)
with the same IDRef number. It seems that this is a job for DSum to
handle when there are multiple occurrences of the same IDRef. Any
assistance provided will be appreciated. Thanks.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.