K
Kevin
In a report, each record has a [Score] that is categorized 1, 2, 3, 4, in a
[GroupID] field. Is it possible to write an expression that will take the
average of each Group, and divide by 4 to obtain an overall average? There
is a Group footer that has each group's average. Is there a way to reference
the group footer, or do I need to reference the [GroupID] in my report footer
expression? Or should I be trying to accomplish this in a query. Any help
is appreciated!
Kevin
[GroupID] field. Is it possible to write an expression that will take the
average of each Group, and divide by 4 to obtain an overall average? There
is a Group footer that has each group's average. Is there a way to reference
the group footer, or do I need to reference the [GroupID] in my report footer
expression? Or should I be trying to accomplish this in a query. Any help
is appreciated!
Kevin