Newbie Excel/Database Question

  • Thread starter Thread starter bobl
  • Start date Start date
B

bobl

I have a database with two tables (class and book) that are joined by a link
table (class_book) such that a class has many books and the same book can be
used in many classes.

How might I go about pulling this data into Excel and showing the classes
down the left side, the books along the top, and an 'X' at the intersection
of the two when a book is required by a class.

TIA,
Bob
 
You can do this with a pivot table. With 2 worksheet columns "Book" an
"Class" holding your data. You might have to do a "Make Table" query i
Access to achieve this.

Use Data/Pivot Table Report to get the Wizard and follow the steps.

At Step 3 of 4 ... put Book in COLUMN, Class in ROW, and Book agai
into DATA (which should change into 'Count of Book').

You will get a 1 instead of an X. If you are really picky, you can Cop
the table and Edit/Paste Special/Values to another sheet, then d
Edit/Replace 1 with X
 
Back
Top