Here am i again,
I would like a hint about having a control in a report with total sum
of several fields. The report works ok but a text box with the sum of
fields from the detail section is missing. I've tried to get the sum
value from a form where the control is placed on the footer of the form. It didnt work the way i did: picking the control from the expression builder of the property window on the report and placing it on the report footer. Would i need to use a subreport and have the sum value as a control on the main report or there is an easy way to have this value displayed on the report?
Any help will be welcome,
rgds P :(

Try http://search.microsoft.com. Search words:

access report sum

There are several articles. Here's a sample page I picked: http://support.microsoft.com/default...b;en-us;296249

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

Thanks Randall,
I'll read ur suggested articles. In the meantime i've used a main report with
no details section only summary where the totals are displayed. Then i have
had a subreport with all the details that are the source of the totals. Though
as the rows on the detail section are product of a transposed query i have used
two record sources: one for the main report and one for the subreport.BTW i thought that this post i've had erased it.
rgds P