I have not recreated your table in my system, just did a quick syntax check.
This is how I would probably construct the query.
-- ********************
Select
-- I have prefixed the fields with the aliased table (p) here
p.[Part Number],
p.[Invt GLG],
Sum(p.PYUsage),
Sum(p.CYUsage)
from...