Report and Group Totals

  • Thread starter Thread starter Berny
  • Start date Start date
B

Berny

Can you please help me with a problem I'm having with my totals?

I have two tables I'm using in a query for my report:

The first table (Table1) has work order information and associated cost per
work order

The second table (Table2) has deficiencies found during inspections

Since a work order may involve the correction of various deficiencies there
is a field in Table2 for a work order number.

I use this field to join Table2 to Table1 which gives me a listing of all
deficiencies that have an assigned work order and the associated cost.

Which is the total work order cost not the cost per deficiency.

The problem is when there are multiple deficiencies using the same work
order.

Since, I'm using only one query for this report each line (deficiency) has
the total work order cost. The same work order cost is repeated for each
deficiency under that work order.

I designed the report to Group on the work order number with the work order
cost displayed in the group; with the associated deficiencies listed in the
detail, everything looks fine until I try to SUM the work order cost at the
report level.

The report total is not just Summing the group level cost of the work order,
it is also including the work order cost from each of the deficiencies.

Can anyone explain how I can get around this problem??

Any help is greatly appreciated!!!!!!!!!
 
Add a text box to the work order Group Header:
Name: txtCostRunSum
Control Source:[CostField]
Running Sum: Over All
Visible: No

Add a text box to the report footer
Control Source: =txtCostRunSum
 
Thank you,

That was the trick I was looking for

Duane Hookom said:
Add a text box to the work order Group Header:
Name: txtCostRunSum
Control Source:[CostField]
Running Sum: Over All
Visible: No

Add a text box to the report footer
Control Source: =txtCostRunSum

--
Duane Hookom
MS Access MVP


Berny said:
Can you please help me with a problem I'm having with my totals?

I have two tables I'm using in a query for my report:

The first table (Table1) has work order information and associated cost per
work order

The second table (Table2) has deficiencies found during inspections

Since a work order may involve the correction of various deficiencies there
is a field in Table2 for a work order number.

I use this field to join Table2 to Table1 which gives me a listing of all
deficiencies that have an assigned work order and the associated cost.

Which is the total work order cost not the cost per deficiency.

The problem is when there are multiple deficiencies using the same work
order.

Since, I'm using only one query for this report each line (deficiency) has
the total work order cost. The same work order cost is repeated for each
deficiency under that work order.

I designed the report to Group on the work order number with the work order
cost displayed in the group; with the associated deficiencies listed in the
detail, everything looks fine until I try to SUM the work order cost at the
report level.

The report total is not just Summing the group level cost of the work order,
it is also including the work order cost from each of the deficiencies.

Can anyone explain how I can get around this problem??

Any help is greatly appreciated!!!!!!!!!
Click to expand...
Click to expand...
 
Back
Top