Search results

  1. 3

    update query

    ok, i have a table called TJ_Table1 and it contains the following fields: TJ_Table1: JNL_Date Amount BRCH TELLER CUSTOMER CHANNEL AMTFIX To update this table, i'm using 6 queries called: -update channel otc UPDATE TJ_Table1 SET TJ_Table1.Channel = "OTC" WHERE...
  2. 3

    update query

    i have no idea of how to use VB code i tried to compile and says syntax error. could you please explain it in more detail. thanks
  3. 3

    update query

    my code is working fine and i'm getting the results that i want, but i wanna make it easier since i'm using 6 updated queries to update a table. however, i'm wondering if there is a better way to combine all queries and make a simple query that do the job. BTW is it possible to use the iif...
  4. 3

    update query

    Hi guys I would like to create a update query that updates more than one fields at a time. I already created a update query for each feild that i want to update. I have 6 feilds to update which i everyday update them in 6 saparate queries and i would like to make my job easier and update them...
Back
Top Bottom