Help with running total

[sammybee]

Hi All,

I have a report with the following:-

EXP INC BAL

5 10 5 (Field1)
6 22 FieldA
9 3 FIeldB

Field 1 is a formula inc - exp
FieldA needs a formula to be field1 - EXP + InC
FieldB needs a formula to be fieldA - eXP + INC

How could I do a formula for this when Fields don't exisist?

THanks

Sam

 

[LittleSmudge]

Set the control Source of BAL to

[INC] - [EXP]

And set the running sum property to Over Group ( or Over ALL ) as appropriate.




'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.