Rpt: crosstab(s) PLUS calculated fields
Posted on 2000-05-09
This probably requires coding a recordset? Do I have a choice?
Got a cross-tab worked up, based on a single table (probably should be on a query, and could I then use two tables?) that has 18 number fields.
I need to "insert" into the cross-tab at print time, the following:
1 field (for each of the 5 output columns) that totals the 4 fields above it.
1 field (for each of the 5 output columns) that shows the difference between a source field and the calculated field.
2 more calculated fields, whose calculations are ratios. I think these also use some calculated data and some "source" data, according to different formulae, tho I'm not yet sure what those formulae are.
The only other way I can think of to do this is to break the one neat cross tab into two, and build an "intermediate" (because it physically has to go in the middle of the displayed "table" query that calculates the new numbers. Will ONE additional query do it?