Cumulative Values

[jimblob21]

Is it possible to add together the values in a column in a subform an

display them in another column in the same subform

 

[chriske911]

jimblob21 laid this down on his screen :

Is it possible to add together the values in a column in a subform and

display them in another column in the same subform?

I take it you are using continous forms
just add a text control and set the source to "= [fieldblabla] +
[fieldyadayada]"
you can use any other mathematical function you like
just take a look in expressions

grtz

 

[Wayne Morgan]

It would be best to do this in the query feeding the subform then bind that
calculated field to the textbox in the desired column.

Example:
SELECT Table1.Field1, DSum("Field1","Table1","ID<=" & [ID]) AS RunningSum
FROM Table1
ORDER BY Table1.ID;