Field on table

I have 2 tables.

One  table Product with fields Product ID and Product Name 
and on , Sales, the fields are Product ID, Customer ID, Location ID, Sales date, sales amount. 

In need to create field which will be the sum of sales amount for each product.Is it possible to get the sales for each product in a column on the table