I am new to access, but I am creating a simple inventory database for work. So far, I have a list of machines and locations feeding a parts info list. Then I made a form to easily input new parts and update the table. Now, I want to show the total quantity for each part. The Key is different, but the part name is the same for some parts so I would like the parts grouped by the Key number. I’ve used the report wizard, but it just shows every transaction not a summary. In my most recent attempt, I got it more condensed, but every part is doubled and not updating.

​I am new to access, but I am creating a simple inventory database for work. So far, I have a list of machines and locations feeding a parts info list. Then I made a form to easily input new parts and update the table. Now, I want to show the total quantity for each part. The Key is different, but the part name is the same for some parts so I would like the parts grouped by the Key number. I’ve used the report wizard, but it just shows every transaction not a summary. In my most recent attempt, I got it more condensed, but every part is doubled and not updating.  Read More

​