| re: DSum Assistance
you might try using an intermediary query
TotalCost=Nz(DSum("SubTotal","qryTotal","IDRef=For ms!frmMain!frmSubForm!IDRe
f"),0)
"Rolan" <basic@safe-mail.net> wrote in message
news:18d2a94.0309240259.2232469e@posting.google.co m...[color=blue]
> 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.[/color]
| 
