Help building Access Report with multiple tables.
Posted on 2007-04-10
I have built an Access database and I need assistance on creating a report. My database is a Product Price catalogue. I have tables for Items, and two separate tables for related itme ( support & maintenance). In addition, I have tables for Product Categories, Product Brands & Requirements. I managed to build a couple of forms that show the Item codes and their related support & maintenacnce codes however I am really struggling with the report. The report needs to show Category, Product Brand (and their requirements) then each Item code, desc, price etc. and then their related support and maintenance codes if they have any then the next item code, support maintenance and so on till it hits the next Product Name.. I just need some direction as I have tried several ways of getting the information on the report with limited success. I am questioning, at this point, whether I even have the database build correct.