How to get tblStudent table record data by input studentCode
There are two tables:
tblStudent:
StudentID autonumber
StudentCode Number ; lookup from StudentCode Table
StudentName short Text
StudentAddress short Text
tblStudentCode:
CodeID autonumber...
Table 1: productCode, purchaseQty, ...
Table 2: productCOde, saleQty,....
I want to create a query that display productCode, sum of purchaseQty, sum of SaleQty.
How to do it in access 2016?
Thanks!