>I have a grid that is being populated by a SQL statement executed on a button click. One of the fields in the grid is a calculated field. The calculation is somewhat complex and is done by calling class code. I do this by calling a form function as the controlsource for the column which creates a new class, executes the class code and returns the result. Naturally, rows in the grid may be members of different classes. I have all this working just fine. My problem is that I cannot seem to find a way to get a total for the column in the grid. I may be doing this all wrong and if I am please set me straight - I really need this total to appear on the screen.
From your description, I'm assuming that the values in the column in question are dynamic, i.e. calculated on the fly. If this be so, could you run a separate SQL statement to get the initial total for the column and display it, then update the total ( if necessary ) by calling a function whenever a value in the column is changed/
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.