Member Avatar for mohd Hisham
mohd Hisham 0 Newbie Poster

i have 2 table
table1 have itemno, qty1 // many item (sum if)
table2 have itemno,qty2,qty

qty = sum (qty1)

i want write value sum of qty1 into column qty in table2.
how to code for this statment, what is declaration for open database and record then edit ot update?

Pls help me

  • 1 Contributor
  • 0 Replies
  • 58 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.