Sum a column in a query and display results in a text box.

[russmann2000]

Hoping I can get some help here. I'm attempting to get the sum of all the values in a column of a query, and display those results in a textbox on a report. This seems like such a simple thing to do but I cannot for the life of me get it to work.

Thank you in advance, I'm a bit of a novice.

[June7]

Could use domain aggregate DSum() expression in textbox.

Otherwise, set the query as the RecordSource of report and use Sum() expression in textbox.

[russmann2000]

I figured it out not long after I posted this. Ended up using DSum.

Thanks for the reply