Update Query

[jhargram]

Hi,


I have 20 rows in a table and I want to update 10 of them only using update query. Please help.

Regards,
Biplab

[rpeare]

You have given no information with which to help you.

Are you changing the same field on all the records?
Are you able to build a query that selects the records you want to change?
Are you changing the 10 records to all be the same value or do they all have different values?
If you're changing them to different values what's the formula for what the new value should be?

[jhargram]

Hi rpeare,

Ok, Table name database and two column data and user. and i have total 100 data but no user details.
Now I create one form with two textbox. One username and another count

if I put "ABC" in username textbox and 20 in count textbox and submit then it should update first 20 user as "ABC" like that...

Thanks..

[rpeare]

That's completely arbitrary why would you choose to change 20 records out of 100 that are conceivably random every time

Let's assume your list of 100 records has 50 records where the username = ABC. If you choose the top 20 (with no other criteria) you will not get the same list of usernames every time and changing a value related to those records will have random (unexpected) results.