How can I pivot a table without using an aggregate function
I have two similar tables - Engagements and Payments. Engagements has: name, amount engaged, year fields - Payments has: name, amount paid, year. I would like to have a report that is grouped by name, pivots the year values and shows both the amount engaged and amount paid ( and the difference) in each "cell". I am using Access and CR.