Search results

  1. K

    Can I Use Sum() Function Along With Update Query?

    I'm trying to use sum() along with UPDATE as shown below UPDATE ALLDATA INNER JOIN [Total Data] ON ALLDATA.PanNumber=[Total Data].PanNumber SET ALLDATA.PLAForMonthPrevYear = sum([Total Data].PLAForMonth), ALLDATA.CENVATForMonthPrevYear = sum([Total Data].CENVATForMonth)...
  2. K

    addition of data in two tables

    i have two tables - all fields are same in two tables. Table1.salary, Table1.Interest, Table1.Bonus Table2.salary, Table2.Interest, Table2.Bonus now i want to add these values and put in a third table. Table3.salary=Table1.salary+Table2.salary Table3.Interest=Table1.Interest+Table2.Interest...
  3. K

    addition of data in two tables

    i have two tables - all fields are same in two tables. Table1.salary, Table1.Interest, Table1.Bonus Table2.salary, Table2.Interest, Table2.Bonus now i want to add these values and put in a thirs table. Table3.salary=Table1.salary+Table2.salary Table3.Interest=Table1.Interest+Table2.Interest...
Back
Top Bottom