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.
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.