Ignore detail records in report totals

[rmcompute]

I created a report which can have 1 to many detail records associated with a
header record. It is based on a query which looks like this:

Item # Item Labor Cost Part # Part Amt
1 1.00 ABC 2.00
1 1.00 DEF 3.00
1 1.00 ABC 2.00
2 2.00 QQQ 3.00
2 2.00 QQQ 3.00

The report has a header record which shows Item 1 Labor 1.00 and Item 2
Labor 2.00. The total labor should be 3.00, but the system adds them as
detail records and creates 7.00. If I group b Item # and create a field to
contain the total labor cost in the header record, is there a way to add only
the header amounts for the total?

 

[Duane Hookom]

You can create a running sum text box in the Item # group header. Name the
control something like [txtLaborRunSum]. Then add a text box in report footer
with a control source of:
=txtLaborRunSum

 

[rmcompute]

As usual you are right on! Thank you.

You can create a running sum text box in the Item # group header. Name the
control something like [txtLaborRunSum]. Then add a text box in report footer
with a control source of:
=txtLaborRunSum

--
Duane Hookom
Microsoft Access MVP

I created a report which can have 1 to many detail records associated with a
header record. It is based on a query which looks like this:

Item # Item Labor Cost Part # Part Amt
1 1.00 ABC 2.00
1 1.00 DEF 3.00
1 1.00 ABC 2.00
2 2.00 QQQ 3.00
2 2.00 QQQ 3.00

The report has a header record which shows Item 1 Labor 1.00 and Item 2
Labor 2.00. The total labor should be 3.00, but the system adds them as
detail records and creates 7.00. If I group b Item # and create a field to
contain the total labor cost in the header record, is there a way to add only
the header amounts for the total?