Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001
    Posts
    175

    Question Unanswered: Updating a table

    I want to update a table based on certain criteria (I wrote some VB code to do the update) but there are several records in the table that match the same criteria. How do I get the code to update just the first record it finds and not all.

    Appreciate any help.

  2. #2
    Join Date
    Sep 2001
    Posts
    46
    1. Use query get the first record that match the criteria[with unique ID]
    Field : FieldToFilter
    Table : Table Name
    Total : Min < ---- with this get First record that match the criteria and use it for further process,say to update first record finded.

Posting Permissions

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