Ignore detail records in report totals

  • Thread starter Thread starter rmcompute
  • Start date Start date
R

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?
 
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
 
As usual you are right on! Thank you.

Duane Hookom said:
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


rmcompute said:
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?
Click to expand...
Click to expand...
 
Back
Top