>I usually do not setup the view for it - I put the code like this into textbox.Refresh()
>
>LOCAL array laTotal[1]
>laTotal[1] = 0
>SELECT SUM(amount) FROM myView as Total
>INTO array laTotal
>this.value = laTotal[1]
>
>Just my 0.02c CDN :)
>
>Nick
Nick, I need a running total on the right side of my detail grid. I already have code nearly identical to yours to calculate the final total in a method called GetAITEMS(). Am I missing something here?
Peter
Peter Robinson ** Rodes Design ** Virginia