[AccessD] Calculate Total All Records

I need to show on a form the total number of items for each type. How do
I track & calculate the beginning total & the total used for all records
for each item?

 

Beginning total

Total used

Total used for all records

 

Ex:

Item: Bench Number 1

Type of item: Bolt

Beginning total: 10

Number used: 5

Total used: This would be the total bolts used for all bolts used for
Bench Number 1.

 

Item: Bench Number 1

Type of item: Bolt

Beginning total: 5

Number used: 3

Total used: 8

 

Virginia