Search results

Thankss. I will try it now.

Wuuu thank You. IT WORKS!! It just my database performance become very slow. can you advise why?

hi.. but format and datepart() cannot use at table. thats y i have to put it long wayyyyy.. 😁

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

I'd tried. but the result not as expected after I converted into my real data. 😢 Actually the scenario is like these. I have two Tables. 1. Customer order (Tbl_Kanban) by date 2. Delivery Order (T02_DO) by date Result I want it to be like this: PartNo KanbanDate KanbanQty DODate DOQty...

Hi this error appear. why? 😢😢

errr stil have question. What if after final query, KQty -SDOQty =-ve. How to bring balance to next date? ex: 1/1/2021 KQty = 50 SDOQty = 100 Balance = -50. Result Balance -50 Should bring to 2/1/2021. Become: KQty = 100 SDOQty = 50 (from balance 1/1/2021) Balance = 50 urghh this one is like...

omaigadddd u just saved my life!! Thankss, It worksss.. xoxo

Hi Arnelgp. Thank you for your reply. However I have question. SDO is comes from another table. not T_Kanban table. Here, I attached my access file. Please help me.

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