How to calculate running sum

[tar28un]

Hi there,

I am trying to calculate sum of two fields in a report. The other two fields are in the two different subforms in the main forms. I am wandering whether it is possible to calculate their sum into a text box into the main form.

 

[dhookom]

Is this a form or report question? You can create text boxes on a main report that reference a total from a subreport. You can set the running sum on this text box to achieve a grand total.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]