Question about summing in a report

  • Thread starter Thread starter PaulHilgeman
  • Start date Start date
P

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
 
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
 
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

PaulHilgeman said:
I am wondering if it is possible to accurately create sums in this
report:
Click to expand...
I have 2 tables. Orders and Order Details
Click to expand...
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.
Click to expand...
Among other data, Order Details contains various line items, their
cost, sale price and installation costs. There are always multiple
line items per order.
Click to expand...
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.
Click to expand...
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?
Click to expand...
Thanks!!!
Paul
Click to expand...
Click to expand...
 
Back
Top