Search results

  1. U

    input a field from a table and get all information from another table

    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...
  2. U

    What's wrong with UNION in this case?

    Access Union Two Table Problem. Attachment document: Access Union Two Table Problem.docx Attachment Database: TW.accdb Please help! Thanks!
  3. U

    How to a query from two tables

    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!
  4. U

    Hello! I am a new member.

    Hi, l am a new member and just begin studying ACCESS. Hope will get help here. Thanks!
Top Bottom