Help with Dlookup or maybe Dsum

[Tuckejam]

still struggling to understand how to use these. I even have them in other parts of my database the others have helped me with and I have spent a fair amount of time playing with it trying to understand and get them to work with this but no luck.

Seems simple enough

I Have a form, and it has a subform and the subform gets it data from a query.

in the query there are some calculated/expression fields



"PastDue = DuesOwed - DuesPaid" and "FinesPastDue = FinesOwed - FinesPaid" And Finally "TotalDue = PastDue + PastDueFines"
(that is oversimplified for the sake o explaining, I do have the expressions correct in the qry fields)

Now I need the sum of all of the numbers in the "TotalDue" column

And I need that to display in the Main form not the subform.

apologies for the artwork below


As always thank you for the help

[Gicu]

Maybe try the following in the control source of the that textbox: =dSum("[TotalDue]","[qry_ChptDuesTrack]")

Cheers,

[ranman256]

in a summation query , put SUM where the EXPRESSION is. (but that way works too)

DSUM & Dlookup are used in a text box. (not a query) =Dlookup("[Fld2Return]","qry/tbl",sWhere)
, where sWhere ="[field]='" & txtBox & "'"

Since your query already does the SUM, then you can just run a:

Dlookup("[TotalDue]","qry","[ClientID]=" & txtID)

[CJ_London]

If this is a form/subform setup then you don’t need the domain function

In the subform footer put a text box with a control source of

=sum(totaldue)

Call the textbox say txttotal

You can the hide the control and on the main form have a textbox with a controlsource of

=nameofsubform.form.txttotal