Recent content by NurulScare

  1. N

    Data automatically update from 1 sheet to another Sheet.

    yes, I did it. but every time refresh updated table will overwrite as well. I want the old data remain. when refresh only add new data. 😭
  2. N

    Data automatically update from 1 sheet to another Sheet.

    Thanks. but my "Sheet" is real time since I linked from access. means every time update in access data will overwrite. so I want to copy paste value to another sheet as for record.
  3. N

    Data automatically update from 1 sheet to another Sheet.

    less more like that. may I know how?
  4. N

    Data automatically update from 1 sheet to another Sheet.

    Hi guys! I have 1 sheet linked from external source but the data is real time (Sheet A). So, I want the data to auto copy (update) to another sheet (Sheet B) to keep the data by date. and the data in Sheet B will continue auto update every time Sheet A refresh. means data will continuous update...
  5. N

    Remove Duplicate for multiple record

    Hi can you explain more about the form?
  6. N

    How to bring forward the running qty to the next day

    Thank you for your explanation. because I really dont have basic about this. and need to do project for my company. so I just do it based on my own way. I realize, many things I still dont understand regarding the structure and etc. especially the importancy of using Primary key. as your no 2...
  7. N

    How to bring forward the running qty to the next day

    Helloo guys! I need help, im newbie in access. Actually i want to create WIP Qty (Qry_WIPQty) based on Production output minus FG go to logistic (FGRS). (The relationship between Table P01_ and P03_FGRS). 1. I already Follow step as per qryUnion and QryFinal 2. However I figure some error, the...
  8. N

    Remove Duplicate for multiple record

    uwaa sorry I cannot understand. huhu im not so advance in ms access. i attached my DB. Actually i want to create WIP Qty (Qry_WIPQty) based on Production output minus FG go to logistic (FGRS). (The relationship between Table P01_ and P03_FGRS). 1. I already Follow ur step as per qryUnion and...
  9. N

    Remove Duplicate for multiple record

    Sorry, I dont understand on Form. why should I put it in form?
  10. N

    Remove Duplicate for multiple record

    Hi, From this I have another question. what if, the Part no transaction. how to bring forward the Qty to the next day? ex: Date PART NO KanbanQty DODate OutstandingKanban 1/8/2021 PART A 100 - 100 2/8/2021 PART A - - 100
  11. N

    to get Max Value between 2 criteria

    Thanksss
  12. N

    to get Max Value between 2 criteria

    Hi, Someone please help me. I have one Table. I need to get Max Qty based on B/S field. Ex: B/S A - 200 A - 500 Max qty = 500. Part No B/S Qty 1 A 200 2 A 500 3 B 1000 4 B 300 5 C 200 6 C 350
  13. N

    Stock Balance by Customer with same Item Code

    Thanks dear. But the problem is I cannot bring the balance to the next customer. Suppose, when I already use the stock for Customer 1st. Then Customer 2nd become less stock. heeee Can you understand my explanation? 😁
  14. N

    Stock Balance by Customer with same Item Code

    Hi, From below example, I have 2 tables: 1. Stock Balance by Item Code 2. Usage by Material Code & Customer Thus, I want to make query to get how many more need to purchase based on stock on hand minus Usage. Below example is, I have different customer SHARE same item. so I want to get...
  15. N

    Retrieved data from latest date.

    Still all date appear even when I put it on criteria.
Top Bottom