I am trying to run a query to total up the quantities for each unique ID on a table.
TypeID is the ID that identifies each unique type. So I need a query to run a total for each unique TypeID. So in the picture above, the query would say TypeID 80 has a total of 15, 79 would have a total of 10 etc. All various instances I have tried, all total the entire lot or dont work at all unless I specifically tell it what ID to total.
Can anyone offer insight on this one?
TypeID is the ID that identifies each unique type. So I need a query to run a total for each unique TypeID. So in the picture above, the query would say TypeID 80 has a total of 15, 79 would have a total of 10 etc. All various instances I have tried, all total the entire lot or dont work at all unless I specifically tell it what ID to total.
Can anyone offer insight on this one?