Is it possible to Sum the values in one particular column in a listbox, within either a form or report, and have the result in a textbox on the form or on the report?
The problem is that the listbox is using a separate query as its source, and the column I wish to sum is a calculated field, tried this before but couldn't get it working. I assumed this wasn't possible using a query as source data.