In addition, use 'SUM' command to make calculations, for example:
SUM MyField TO MyVar
You can also use SELECT SQL command to calculate sum, but this command does not reflect changes when cursor is buffered.
>Sammy,
>
>You could add a textbox to the form and place it below the column to total. You could have a method (e.g. ThisForm.CalcColumnTotal) that calculates the total and updates textbox.value. You'd have to call this method whenever the contents of the grid changes.
>
>Hope this helps.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.