Stuck- Urgent

[sara_heideman]

I need help - I have a crosstab query showing activity by territory,
with totals and averages that looks like this:

Terr1 Terr2 Terr3 Terr4 Terr5 Total
Avg
ActivityA
ActivityB
ActivityC
ActivityD
ActivityE

My issue comes with the fact that some of the totals for the
activities are not a straight sum across - for example, the total for
ActivityD= sumof ActivityB / sum of ActivityA. The column name for the
activities in the crosstab design view is Explanation. Is there a way
to use If,then statements in the totals column to perform different
functions based on the value of the Explanation?

Thanks!

 

[Jeff Boyce]

If I were faced with a variety of raw data/output, and needed to do further
processing on it (e.g., your division to calculate ActivityD...), I'd export
the raw data to Excel and use Excel to do the further calculations.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP