Results 1 to 4 of 4
  1. #1
    jhargram is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    40

    Update Query

    Hi,


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

    Regards,
    Biplab

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    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?

  3. #3
    jhargram is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    40
    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..

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update query won't update table
    By bonesie in forum Access
    Replies: 6
    Last Post: 01-15-2013, 05:22 PM
  2. Replies: 2
    Last Post: 08-30-2012, 07:59 AM
  3. Replies: 4
    Last Post: 11-10-2011, 03:41 PM
  4. Replies: 1
    Last Post: 08-19-2011, 12:16 PM
  5. Update 2 tables with one Update Query
    By Douglasrac in forum Queries
    Replies: 4
    Last Post: 04-14-2011, 08:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums