1. Create a quick report and make detail record the way you want
2. Create Report Group on ProductID
2.1 Create fields in the Group footer and set there source and calculations the way you like.
>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.
>
--sb--