Unable to get group totals to calculate...

  • Thread starter Thread starter sabrown
  • Start date Start date
S

sabrown

I have created a report that has several calculated controls in it. I
have been unable to get a total at any group level by any of the
recommended =Sum() syntax. For example...

Detail control...

BIN$=IIf([SUGGMODL]="BIN",[ESTINV$],0)

At group level have tried...

=Sum(IIf([SUGGMODL]="BIN",[ESTINV$],0))

and

=IIF(Sum(SUGGMODL]="BIN",Sum([ESTINV$]),0))

I keep getting parameter entry dialogs for SUGGMODL and ESTINV$???
 
Move the control calculation to the query that works as the record source of
the report:

-In the query design add a column:

BIN$:IIf([SUGGMODL]="BIN",[ESTINV$],0)

-On your report change the control to point to BIN$
-Change your totals and group soubtotals to:

=sum([BIN$])
 
Thanks - I know that works but this is a very big query and I am trying
to keep the calculations out of the query.

I was able to finally get a running sum approach to work.
 
Back
Top