Recent content by jk.

i have tbl_A that list out the open order detail. tbl_B contain the detail of a package. I have join this table using query,Old Item Code as the key and make tbl_C. 1 Old Item Code could have more than one open order. Let say i have package 1, Old Item Code = acb, TotalQty = 300 when i join...

hi elliotgr,thanks for your rep and its work.. I have another question. i have a table tbl_P with 11 fields. col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 ab 123 eer 100 235 rerr reer eerr 50 50 eerr ab 123...

I am trying to write an If then else statement in Access. i have query mkePallet which is join from tbl_A and tbl_B using Material Code. my statement needs to be something like this: if TotalQty = OpenQty,New total = OpenQty else if TotalQty < OpenQty, New total = TotalQty else New...

hi everyone.. im stuck with this for whole week:banghead: i have a query q_mkeA that i join tbl_A and tbl_B.. palletNum item code TotalQty OpenQty NewTotal 1 abc 100 50 50 1 abc 100 50 50 2...

hello! im mary from malaysia..im a newbie in access..i hope i can learn more in this forum help you guys can help me to complete my new project..;)