J
jacobh
Hi group.
I have a MS Access table with fields
PersonID
AccountNo
Amount
And I'd like to make a report that generates a matrix where each column
corresponds to one account number and each row corresponds to a person.
Each cell in the matrix should be the sum af the amounts for the particular
person and account.
And I'd like a sum in the bottom row. Sounds simple? How do I do it? Sorry,
I'm a beginner in using Access like this.
I don't know in advance which possible account numbers there might be, so
the report could get quite wide. I hope thats not a problem to Access?
Thanks for any help!
Jacob
I have a MS Access table with fields
PersonID
AccountNo
Amount
And I'd like to make a report that generates a matrix where each column
corresponds to one account number and each row corresponds to a person.
Each cell in the matrix should be the sum af the amounts for the particular
person and account.
And I'd like a sum in the bottom row. Sounds simple? How do I do it? Sorry,
I'm a beginner in using Access like this.
I don't know in advance which possible account numbers there might be, so
the report could get quite wide. I hope thats not a problem to Access?
Thanks for any help!
Jacob