i need an query for update my record added by old value and new updated value \

here is my query :
conn.Execute ("Update Medicine_Details SET UnitsInStock='" & rs3.Fields.Item(3).Value & "' where ProductID='" & rs3.Fields.Item(2).Value & "'")

but i dont know how to use sum in function these query working updating record but i need updating and counting also existing record ...

Re: i need update my record as added by old value and new updated value 80 80

Is this what you need?

("Update Medicine_Details SET UnitsInStock = UnitsInStock + " & rs3.Fields.Item(3).Value & " where ProductID='" & rs3.Fields.Item(2).Value & "'")

Re: i need update my record as added by old value and new updated value 80 80

thank you dude DaveAmour

Be a part of the DaniWeb community

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