Grouping in Forms

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

Hello,

I have a group in my form called DrawingStage. There is New, OutForApproal,
and InProduction. I am summing each group.

So far everything is great.

Now, in the report footer, I want to sum up New and OutForApproval together.
How do I sum up two specific groupings?

Thanks for your help.

-Joel
 
Joel,

There are a couple ways I can think of:

Not sure it is the smoothest way to go, but in the past I have added a
hidden calculated field in either the underlying dataset or the form itself
that conditional sums the field you are wanting to add together. I.e.
SumField: iif([field]<>"InProduction",[field],0). Then sum "SumField" in the
form/report footer...

Second, you could create a subform whose dataset is based on a query that
sums only those two types of stages.

Alternatively, if you are good with ADO recordsets and VBA, you could
calculate the value in vb and set the value of a summary field in the footer.
Have the vb function re-calc each time a value is updated on the form...

Regards,
Doug Miller
 
Back
Top