Search results

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

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

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

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

Hi all, Good Morning!! I need your advise guys. I have 2 tables 1. Quantity In by date 2. Quantity out by date. Result: Quantity balance by date. The problem is: I want to check my Quantity balance by latest date. Example below: Scenario: From this stock balance, I want to create another...

Hi, I want to create pivot from Query. I think the best way for me is to linked access query to excel. however I cannot find way to do that. Can someone please advise:

Hi, I have table and need to calculate WEEK NUMBER based on date. however when enter year 2021, My week 1 doesn't start with 27/12/2020. date 27/12/2020 become week 53. I want my week 1 start with 27/12/2020 (Sunday is 1st day) my formula is: IIf([Rejection Year]=2019,Int((([Rejection...

Hi, sorry since Im a newbie. i have lots of question to ask. I have data as below: ID QTY DATE A 100 1/1/2021 B 55 2/1/2021 C 60 3/1/2021 But I want to transform it become like below: ID 1/1/2021 2/1/2021 3/1/2021 A 100 B 55 C 60 really need your help guyss...

Hi, help me. im Newbie in Access. I Have 2 tables. 1. T_Kanban field: Part No, Date, Qty 2. T_DO Field: Part No and Qty Issue: I want to get variance Qty Which mean, [T_Kanban.Qty]-[T_DO.Qty]. However, Qty for T_DO appear as multiple record. actually Qty=50 should only appear once. the...