You can put the same fields in the group footer (report footer) and check SUM in calculation options.

>I have a set of reports to design and the quick report or wizard does not let me do the following:
>
>All tables have four id fields that make them individual
>1. ProductID
>2 Product Name
>3. Quantity
>4. Lot Number (AutoInc Integer Field)
>
>I have a lot of data and about a dozen products, on each product id (1 or XXX number) of records needs to have a product id sum or total of all records in the table at the end of the current record on the report.
>
>Also all these fields are tables inside a .dbc
>
>I hope I have worded this properly.
>
>
>Thanks in advance for any help
>
>Still learning Fox
>
>Fred W.