To update, I got what I need by using "DSum" as the "Control Source" for the textbox on the form...
=DSum("Job_Billed_Amount","Not Paid Query")
where
Job_Billed_Amount is the field from which I want to sum the values, and
"Not Paid Query" is the query containing those values in its result.
Thanks for your time on this.
=DSum("Job_Billed_Amount","Not Paid Query")
where
Job_Billed_Amount is the field from which I want to sum the values, and
"Not Paid Query" is the query containing those values in its result.
Thanks for your time on this.