I have a table that utilizes a compound key for parts tracking. Below is an example table:
Set Part Type Status A Orange Out for repair A Apple Installed A Banana Scrapped B Orange Installed B Apple Sold B Banana Ready for Installation
My "Set" and "Part Type" are used for my Primary Key. I would like to develop a report that outputs a table summarizing the status of all parts. Example report below:
Set Oranges Apples Bananas A Out for Repair Installed Scrapped B Installed Sold Ready for Installation
Does anyone have any ideas what the best approach would be for this?
By way of my own background, I am VERY VERY new to Access, and database design in general. I have developed very complex and vba-intensive excel spreadsheets in the past, so it's not like this is my first time in front of a computer. However the learning curve to Access has proven steep and difficult, so thanks in advance for your patience .