Running sums in a cont. form 1

[kennetha]

Hi all,

I've created a cont. form (Stock Card) with Qtyin, Qutout and some other data which I would like to add a running balance; ie. Qtyin-Qtyout. I noticed that this is possible in a report by Running Sum.

Is it possible to do this in a form

Thanks in advance
Kenneth

 

[Remou]

Not as such, but it should be possible to use DSum. For example:

[tt]=DSum("[Count]","Table1","ID<=" & [ID])[/tt]

 

[TheAceMan1]

How are ya kennetha . . .

Perhaps faq702-5248 will do? . . .

See Ya! . . . . . .

 

[kennetha]

Thanks man Faq702-5248 is what I needed