If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum In Report Footer
I have this in a Report Group Header
its an unbound field =DCount("PartyStatus","tblPartyPlannerDetails","Pa rtyStatus=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","Pa rtyStatus=1") I also tried Sum(=DCount("PartyStatus","tblPartyPlannerDetails" ,"PartyStatus=1")) Nothing seemed to add up the values. Thanks DS |
#2
|
|||
|
|||
Sum In Report Footer
DS wrote:
I have this in a Report Group Header its an unbound field =DCount("PartyStatus","tblPartyPlannerDetails","P artyStatus=1 AND PartyNameID = Reports!rptFXEventStats!PartyNameID") How do I get the Sum of this in a Report Footer? 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 -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Sum In Report Footer
Marshall Barton wrote:
DS wrote: 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? 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 Thanks Marsh, That works I also dug this up from something that you did earlier... =Sum(IIf([PartyStatus]=1,1,0)) DS |
#4
|
|||
|
|||
Sum In Report Footer
DS wrote:
Marshall Barton wrote: DS wrote: 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? 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 Thanks Marsh, That works I also dug this up from something that you did earlier... =Sum(IIf([PartyStatus]=1,1,0)) That would be preferable if you are grouping on the PartyNameID field. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|