Matrix report question

  • Thread starter Thread starter jacobh
  • Start date Start date
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
 
Start by creating a crosstab query. Set all possible account numbers as the
Column Headings property of the crosstab query.
 
Back
Top