Sum Columns

Jonno

Registered User.
Local time
Today, 03:37
Joined
Mar 17, 2003
Messages
74
Hi all

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?
 
Sure - Do a dsum() on the same data the list box is using.


???
 
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.
 

Users who are viewing this thread

Back
Top Bottom