Search results

  1. U

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

    What I want to do is: use lookup display studentCode, then I select a StudentCode, and get the match student information and display in the screen.
  2. U

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

    What I want to do is: use lookup display studentCode, then I select a StudentCode, and get the match student information and display in the screen.
  3. 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...
  4. 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!
  5. 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!
  6. 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