How do I create a Matrix in Excel from information in an Access Ta

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to import data into excel in the form of a table/matrix for ease
of viewing some of the data in my access database. I have a table of
Controls, a table of Risks, and a Table that is connected to the other two in
a many-many relationship. The goal is to have the excel matrix show risks on
the left side, controls across the top and a letter from the third table that
corresponds to the risk/control pairs. I have tried a pivot table and this
almost works, except instead of displaying letters it displays a 1. Any help
with this would be greatly appreciated.

Thanks.
 
Try using a crosstab query in Access, then export that. For the
"function" to be calculated for each intersection of Control and Risk,
select First (or maybe Max, Min or Last).
 
Back
Top