wonky subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys,

Im having a bugger of problem with the subtotals of my report

It is a master/ detail relationship. Invoices to commissions payments.
There may be many payments for one invoice.

I have a field "Potential commission" that I only want to add once per
invoice, . It is in the a grouping header called number header. I want to
sum this at the report footer. It sums great unless there is more than one
detail then the potential commission duplicates for that invoice. I only
want to add it once per invoice.

I also tried an alternative, to do a field set to potential commission that
is set to "sum overall" Then in the rport footer I have the source set to
this field. It is really weird. Sometimes it works for one employee and
other times, it will only take the value from the potential commission from
the first invoice???? Really weird.

Any suggestions, Im dying to find a solution.
thanks,Dp
 
Try create these text box controls:
Section: Number Header
Name: txtPotComRunSum
Control Source: [Potential commission]
Running Sum: Over All
Visible: No
and
Section: Report Footer
Control Source: =txtPotComRunSum
 
Thanks Duane:

That did the trick
I don't know what I would do without this newsgroup...probably jump off my
balcony...

Cheers,
David

Duane Hookom said:
Try create these text box controls:
Section: Number Header
Name: txtPotComRunSum
Control Source: [Potential commission]
Running Sum: Over All
Visible: No
and
Section: Report Footer
Control Source: =txtPotComRunSum

--
Duane Hookom
MS Access MVP
--

dp said:
Hi guys,

Im having a bugger of problem with the subtotals of my report

It is a master/ detail relationship. Invoices to commissions payments.
There may be many payments for one invoice.

I have a field "Potential commission" that I only want to add once per
invoice, . It is in the a grouping header called number header. I want to
sum this at the report footer. It sums great unless there is more than
one
detail then the potential commission duplicates for that invoice. I only
want to add it once per invoice.

I also tried an alternative, to do a field set to potential commission
that
is set to "sum overall" Then in the rport footer I have the source set to
this field. It is really weird. Sometimes it works for one employee and
other times, it will only take the value from the potential commission
from
the first invoice???? Really weird.

Any suggestions, Im dying to find a solution.
thanks,Dp
Click to expand...
Click to expand...
 
You have a balcony? Very cool... ;-)
My life is spent pretty much on one boring level.

--
Duane Hookom
MS Access MVP
--

dp said:
Thanks Duane:

That did the trick
I don't know what I would do without this newsgroup...probably jump off my
balcony...

Cheers,
David

Duane Hookom said:
Try create these text box controls:
Section: Number Header
Name: txtPotComRunSum
Control Source: [Potential commission]
Running Sum: Over All
Visible: No
and
Section: Report Footer
Control Source: =txtPotComRunSum

--
Duane Hookom
MS Access MVP
--

dp said:
Hi guys,

Im having a bugger of problem with the subtotals of my report

It is a master/ detail relationship. Invoices to commissions payments.
There may be many payments for one invoice.

I have a field "Potential commission" that I only want to add once per
invoice, . It is in the a grouping header called number header. I want
to
sum this at the report footer. It sums great unless there is more than
one
detail then the potential commission duplicates for that invoice. I
only
want to add it once per invoice.

I also tried an alternative, to do a field set to potential commission
that
is set to "sum overall" Then in the rport footer I have the source set
to
this field. It is really weird. Sometimes it works for one employee
and
other times, it will only take the value from the potential commission
from
the first invoice???? Really weird.

Any suggestions, Im dying to find a solution.
thanks,Dp
Click to expand...
Click to expand...
Click to expand...
 
Back
Top