Calculating differences between some but not all summary figures

  • Thread starter Thread starter Hawthorne 53
  • Start date Start date
H

Hawthorne 53

Is there a technique in report writing (Access 2007) for showing the
difference between two separate summary figures. The problem arises when
there are several such pairs (if there was only one pair it probably could be
handled at the "Detail" level of the report. Also easily handled in Excel)
By way of example, assume there are several accounts with some, but not all,
of those accounts being conceptually paired – say "instructional fees" and
"instructional expense". For such pairs one wants to show the calculated
"net" amount, namely ("instructional fees" less "instructional expense").
One might have the following 8 accounts, showing sums for the transactions,
and in addition two calculated "net" subaccounts, "Net Instructional Fees"
and. "Net Special Events", derived from the difference between two pairs of
sums.
Tuition 2000
Instructional Fees 400
Instructional Expense 100
Net Instructional Fees 300
Library 150
Catalog 75
Special Events Income 500
Special Events Expenses 275
Net Special Events 225
Telephone 80
 
I expect you should create a table that describes the pairing. I wouldn't go
any further until this was set up.
 
Back
Top