 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2004Newbie Excel/Database Question
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 -- Message posted from http://www.ExcelForum.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.