I have a report like this:
Rpt Header: *empty*
Item Header: Item, desc, amount
Detail: initials, repair_date, repair_desc
Item Footer: *empty*
Rpt Footer: =sum([Amount])
Item, desc and amount are in one table (parts). initials, repair_date and repair_desc are in a related table (repairs)
The field in the report footer works fine, as long as there is only ONE repair on the part. As soon as someone repairs a part twice, the =sum([amount]) starts to deviate.
I can almost see why this is happening, but I don't know how to prevent it!
Any help greatly appreciated.
Rpt Header: *empty*
Item Header: Item, desc, amount
Detail: initials, repair_date, repair_desc
Item Footer: *empty*
Rpt Footer: =sum([Amount])
Item, desc and amount are in one table (parts). initials, repair_date and repair_desc are in a related table (repairs)
The field in the report footer works fine, as long as there is only ONE repair on the part. As soon as someone repairs a part twice, the =sum([amount]) starts to deviate.
I can almost see why this is happening, but I don't know how to prevent it!
Any help greatly appreciated.
