Summing unbound text boxes

[Kevin Bruce]

The report I'm creating is an invoice that can list many different items in
the detail section and then sum them in the footer. The fee for each item is
rather complicated to calculate and so has been done in VBA which then
assigns the value to the textbox in the detail section of the report. The
problem I'm having is that I don't know how to sum the total in the footer.
Copying the text box and adding a Sum function does not work, I suppose,
because it's an unbound textbox.

Any help would be appreciated. Thanks in advance.

_Kevin

 

[SA]

Kevin:

You've got to also do that in VBA. Dimension a variable to contain the sum
in the reports general declarations section. Then in the on Print event add
the value you are calc'ing to that variable; assigning it to the control in
the report or group footer (remember if you do this in groups to reset the
variable to 0 in the group header.)