Question about summing in a report

[PaulHilgeman]

I am wondering if it is possible to accurately create sums in this
report:

I have 2 tables. Orders and Order Details

Among other data, Orders contains a field "Total Income" which is the
total income for the job, automatically recorded before any deposits
or payments are made against an outstanding balance.

Among other data, Order Details contains various line items, their
cost, sale price and installation costs. There are always multiple
line items per order.

When I create a report to tally everything up, the field TotalIncome
gets added on a per-line item basis, making it way way too big.

Any idea how to get this to work correctly, So that I am totaling
"TotalIncome" per job, but totaling "Cost" "SalePrice" and
"InstallCost" per line item?

Thanks!!!
Paul

 

[Duane Hookom]

If you report has only one Order then just use the Total Income field with no
Sum(). If you have multiple Orders, then create a text box in the Order
header or footer:
txtName: txtTotIncRunSum
Control Source: [TotalIncome]
Running Sum: Over All
Visible: No
Then in the report footer you can use a text box:
Control Source: txtTotIncRunSum

 

[PaulHilgeman]

Great, I will try that.

Thanks!

If you report has only one Order then just use the Total Income field with no
Sum(). If you have multiple Orders, then create a text box in the Order
header or footer:
txtName: txtTotIncRunSum
Control Source: [TotalIncome]
Running Sum: Over All
Visible: No
Then in the report footer you can use a text box:
Control Source: txtTotIncRunSum

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCPhttp://www.access.hookom.net/UCP/Default.htm

I am wondering if it is possible to accurately create sums in this
report:

I have 2 tables. Orders and Order Details

Among other data, Orders contains a field "Total Income" which is the
total income for the job, automatically recorded before any deposits
or payments are made against an outstanding balance.

Among other data, Order Details contains various line items, their
cost, sale price and installation costs. There are always multiple
line items per order.

When I create a report to tally everything up, the field TotalIncome
gets added on a per-line item basis, making it way way too big.

Any idea how to get this to work correctly, So that I am totaling
"TotalIncome" per job, but totaling "Cost" "SalePrice" and
"InstallCost" per line item?

Thanks!!!
Paul