My table structures:
Master: (one record per group)
Group
Group Description
CostCtr: (multiple Cost Center per group
Group
Cost Center
Cost Center Description
Detail Transactions: (multiple Transactions per Cost Center)
Cost Center
Account Number
Voucher
Amount
Date
I have a query that...