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
|
|||
|
|||
subtotal of total of some of the groups
i have my report grouped by dept # ex. depts 1thru 7 each group has its own
subtotal of sum[reg pay] by dept and I have a grand total for all of the groups. I want to total the subtotals of depts 1 thru 4 not sure of the exact formula do I use an Iif and how do I say 1 thru 4??? what am i missing? thanks, barb |
#2
|
|||
|
|||
subtotal of total of some of the groups
In the group footer, you could try setting the field to:
=Sum(iif([DeptNum] 5), [reg pay], 0) |
#3
|
|||
|
|||
subtotal of total of some of the groups
I am getting the error
expression has the wrong number of arguments with the below syntax??? I am putting it in the report footer because i want it to only sum up where the deptnum is 5 and then take that total and subtract it from the grand total. thanks, barb "ghetto_banjo" wrote: In the group footer, you could try setting the field to: =Sum(iif([DeptNum] 5), [reg pay], 0) |
#4
|
|||
|
|||
subtotal of total of some of the groups
babs wrote:
I am getting the error expression has the wrong number of arguments with the below syntax??? I am putting it in the report footer because i want it to only sum up where the deptnum is 5 and then take that total and subtract it from the grand total. "ghetto_banjo" wrote: In the group footer, you could try setting the field to: =Sum(iif([DeptNum] 5), [reg pay], 0) A paren is in the wrong place. Try using: =Sum([reg pay]) - Sum(iIf(DeptNum 5, [reg pay], 0)) -- Marsh MVP [MS Access] |
#5
|
|||
|
|||
subtotal of total of some of the groups
Thanks got it - had to put [Dept Name] - otherwise Perfect!!!
"Marshall Barton" wrote: babs wrote: I am getting the error expression has the wrong number of arguments with the below syntax??? I am putting it in the report footer because i want it to only sum up where the deptnum is 5 and then take that total and subtract it from the grand total. "ghetto_banjo" wrote: In the group footer, you could try setting the field to: =Sum(iif([DeptNum] 5), [reg pay], 0) A paren is in the wrong place. Try using: =Sum([reg pay]) - Sum(iIf(DeptNum 5, [reg pay], 0)) -- Marsh MVP [MS Access] |
#6
|
|||
|
|||
subtotal of total of some of the groups
just got back to doing this report and I am putting the formula into the
deptnum Footer - it is grouped by deptnum. so the if then I am using is just Looking at the dept num within that group so the answer of this formula =Sum(IIf([cost id]5,[reg pay],0)) and just Sum([reg pay]) is identical - where do I put it so can see the dept. among All the groups. so the sum of dept num 4 for ALL of the dept - both formula answers are identical - I want a GRand total for dept 1t through 4??? thanks, barb "Marshall Barton" wrote: babs wrote: I am getting the error expression has the wrong number of arguments with the below syntax??? I am putting it in the report footer because i want it to only sum up where the deptnum is 5 and then take that total and subtract it from the grand total. "ghetto_banjo" wrote: In the group footer, you could try setting the field to: =Sum(iif([DeptNum] 5), [reg pay], 0) A paren is in the wrong place. Try using: =Sum([reg pay]) - Sum(iIf(DeptNum 5, [reg pay], 0)) -- Marsh MVP [MS Access] |
#7
|
|||
|
|||
subtotal of total of some of the groups
I want to show the totals at the end of Dept num 4 AS WELL AS at the end of the Report - I can put them in the report header and it works but HOW can I put this in the end of DEpt 4??? thanks,barb "Marshall Barton" wrote: babs wrote: I am getting the error expression has the wrong number of arguments with the below syntax??? I am putting it in the report footer because i want it to only sum up where the deptnum is 5 and then take that total and subtract it from the grand total. "ghetto_banjo" wrote: In the group footer, you could try setting the field to: =Sum(iif([DeptNum] 5), [reg pay], 0) A paren is in the wrong place. Try using: =Sum([reg pay]) - Sum(iIf(DeptNum 5, [reg pay], 0)) -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|