How to Create Total Of Only Each Field In Table

[Burhanuddin]

like i have created table nd field are product name , product opening qty,total purchase,total sales,


now i have to do that in my 1st product which i have do purchase entry of that of qty 20 then automatically show in Field (Total Purchase In Front Of ProduCT nAME)

[ranman256]

in the query Q1 get the sums:
select prod,TotalQtySold: Sum(Qty),TotalAmtSold: Sum(AmtPd) from tData between date1 and date2

in query Q2, use the tData table and Q1 joined on Product code:
select tData.Prod, tData.OpenQty , Q1.TotalQtySold, Q1.TotalAmtSold from Q1,tData where Q1.Prod = tData.Prod