Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Loop to update Duplicates

Status
Not open for further replies.
laman

laman

Technical User
Jan 24, 2002
44
US
I need some help with this one. I have a find duplicates query named "DupRecords". I would like to leave the first record as is but update the duplicates field5 to="Y". Some kind of loop?

Please Help
Thanks
 
Sort by date Sort by votes
Laman, are you referring to all the queries under the query folder that have a name with the partial name 'DupRecords' and each has a field5 that you want to update except for the first one?
 
Upvote 0 Downvote
Thanks for the response but I figured it out.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
416
Kennelbloke
Kennelbloke
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
251
dhookom
dhookom
aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
178
aldi07
aldi07
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
184
Viswa.R
Viswa.R
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
262
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top