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.