Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Question Unanswered: Using an update query to update Top values

    Hi, I have an update query and I would like to only update 100 records at a time. But Top Values is not an option for an update query. Are there any functions I can use which would do the same thing?

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    It is if you use a subquery as your criteria.


    WHERE yourIdField IN (SELECT TOP 100 yourIdField FROM yourTable)
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts