how to get current sum

R

rodchar

hey all,

i have a invoice report and line items subreport and was wondering how do i
total the line item cost at the bottom of the report?

thanks,
rodchar
 
S

Steve Schapel

Rodchar,

One option would be to put an unvbound textbox in the Report Footer
section of the subreport, and set its Control Source property to the
equivalent of...
=Sum([Cost])
 
R

rodchar

thanks, that worked.

Steve Schapel said:
Rodchar,

One option would be to put an unvbound textbox in the Report Footer
section of the subreport, and set its Control Source property to the
equivalent of...
=Sum([Cost])

--
Steve Schapel, Microsoft Access MVP
hey all,

i have a invoice report and line items subreport and was wondering how do i
total the line item cost at the bottom of the report?

thanks,
rodchar
 
Top