Search results

  1. B

    I want to create 3 queries from 3 tables

    yo you use winrar or winzip soft to open it
  2. B

    I want to create 3 queries from 3 tables

    1. I'm not good at English so that I can't express my ideas and I have to use image to specify what I'd like to do. 2. I think only 2 tables: 1. "Tb1" table is unique value "GT". I can combine MaID and MaH into "Tb1" table and the other table "Tb2" 3. "data" table has 5 columns such as date...
  3. B

    I want to create 3 queries from 3 tables

    1. Yes, I did data table by excel. 2. Now, I want to make the data table by query in microsoft access You can design or organize table to make query in access ?
  4. B

    I want to create 3 queries from 3 tables

    Hi Everyone, I want to create 3 query based on 3 tables 3 query like images in the attachment Looking forward to receiving from your reply. Thank you
  5. B

    dynamic field in query to table

    Hi u, Pls help to write vba code for append query with dynamic field to table ie: such as append query "F5A1,.." to table "s_test" "F5A1" query: INSERT INTO STYLE5A ( ID, NPL, DVT, A, B, C, D, E, F, G, H, I, J, CNN ) SELECT CR5ADM.ID AS ID, CR5ADM.NPL AS NPL, CR5ADM.DVT AS DVT, CR5ADM.[1]...
  6. B

    Only show balance (running sum) for last record on that date

    send your the attachment to help
  7. B

    Query to show last balance of each customer

    Pls send specific report sample to help.
  8. B

    crosstab query column headings

    send your the attachment to help!
  9. B

    Crosstab query to show two values that use the same column heading

    Pls send the attachment to help
  10. B

    dynamic append query

    Hi John Big Booty, Thanks for yr reply. However my code didn't run. Pls check & repair my code to run dynamic append query. Thanks&Regards, Tam Binh
  11. B

    dynamic append query

    Hi, I'd like to use vba to make a dynamic append query with button "update" on form1. however It's error. I looking forward to receive your help, thanks! Thanks&Regards, Tam Binh
Back
Top Bottom