View Single Post
  #2 (permalink)  
Old January 16th, 2008, 01:51 PM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Do you have the table structure and the fields you want modified? Why would you process the whole table at one time rather than as needed for a report or other view? And then only those records?

Basically you take the PartID, then create a recordset on the table using that as the criteria.

Can you post the table(s) you want to use and modify? I am not sure from you post if you want to find a record in a table and modify it, or find a record in a table and modify all records in the table, or find a record in the table and modify a record in another table.



mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote