Thanks Jared for your inputs, i did go through the article provided by, for Rookie query i updated it little and use it and just provided 3 record set as...

Thanks Rookie it worked. 🙂

Thanks for your replies

Yes, i believe i provided wrong set of data for example, i wanted to update a table for a newly added column "Balance"

I wanted a single...

Yes, i believe i provided wrong set of data for example, i wanted to update a table for a newly added column "Balance"

I wanted a single update query which...