Sum In Report Footer

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have this in a Report Group Header
its an unbound field

=DCount("PartyStatus","tblPartyPlannerDetails","PartyStatus=1 AND
PartyNameID = Reports!rptFXEventStats!PartyNameID")

How do I get the Sum of this in a Report Footer?

I tried Sum([TxtStatus1])

I tried =DCount("PartyStatus","tblPartyPlannerDetails","PartyStatus=1")

I also tried
Sum(=DCount("PartyStatus","tblPartyPlannerDetails","PartyStatus=1"))

Nothing seemed to add up the values.

Thanks
DS
 
DS said:
I have this in a Report Group Header
its an unbound field

=DCount("PartyStatus","tblPartyPlannerDetails","PartyStatus=1 AND
PartyNameID = Reports!rptFXEventStats!PartyNameID")

How do I get the Sum of this in a Report Footer?
Click to expand...


Add a hidden text box (named txtRunSum) to the header
section, next to the DCount text box. Set its control
source expression to =thedcounttextbox and its RunningSUm
property to Over All.

Then the report footer text box an display the total by
using the expression =txtRunSum
 
Marshall said:
DS wrote:





Add a hidden text box (named txtRunSum) to the header
section, next to the DCount text box. Set its control
source expression to =thedcounttextbox and its RunningSUm
property to Over All.

Then the report footer text box an display the total by
using the expression =txtRunSum
Click to expand...
Thanks Marsh, That works I also dug this up from something that you did
earlier...

=Sum(IIf([PartyStatus]=1,1,0))

DS
 
DS said:
Marshall said:
Add a hidden text box (named txtRunSum) to the header
section, next to the DCount text box. Set its control
source expression to =thedcounttextbox and its RunningSUm
property to Over All.

Then the report footer text box an display the total by
using the expression =txtRunSum
Click to expand...
Thanks Marsh, That works I also dug this up from something that you did
earlier...

=Sum(IIf([PartyStatus]=1,1,0))
Click to expand...


That would be preferable if you are grouping on the
PartyNameID field.
 
Back
Top