Search results

  1. J

    if else statement

    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...
    • jk.
    • Thread
    • Replies: 5
    • Forum: Queries
  2. J

    checking the next line...

    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...
    • jk.
    • Thread
    • Replies: 1
    • Forum: Queries
  3. J

    hello everyone..

    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..;)
Back
Top Bottom