within my form i have a tquery, tdatasource, tdatabase and dbgrid. when i run a given query it will feed back that data to the dbgrid. my question is that of the several columns of data displayed their is for example one column that contains cost prices. is there a way that upon the data being received that a given column can be totalled up and displayed within a label or similer on the form. that way giving me a total price of goods rather than adding up 100+ lines manually.
The connection type that this uses is BDE and sql server querying