Hey, I need to have code that does the same thing as this code, except it needs to run A LOT faster! The database is huge so when you go through the code, remember that there are a lot of entries. the problem is with IC-JOBITEM as it is a query with 32000 entries and it checks it every loop. I need a quicker way to do it, but my brain isn't working today. rst2 has like 366 items, so right now it scans the 32000 entry table 366 times, which takes a long time obviously! <br>----------<br> Do Until rst2.EOF<br> <br> rst.MoveFirst<br> i = 1<br> check = rst2!Item<br> <br> Do Until rst.EOF<br> If rst!Item = check Then<br> If i = 1 And check = rst!Item Then<br> rst3.AddNew<br> rst3!Item = check<br> rst3!qty = rst!qty<br> rst3!cost = rst!cost<br> check2 = rst!cost<br> rst3!transdate = rst!daterec<br> rst3!vendor = rst!vendor<br> rst3.Update<br> rst3.Bookmark = rst3.LastModified<br> rst.MoveNext<br> i = i + 1<br> ElseIf i = 2 And check = rst!Item And check2 <> rst!cost Then<br> rst3.AddNew<br> rst3!Item = check<br> rst3!qty = rst!qty<br> rst3!cost = rst!cost<br> check2 = rst!cost<br> rst3!transdate = rst!daterec<br> rst3!vendor = rst!vendor<br> rst3.Update<br> rst3.Bookmark = rst3.LastModified<br> rst.MoveNext<br> i = i + 1<br> ElseIf i = 3 And check = rst!Item And check2 <> rst!cost Then<br> rst3.AddNew<br> rst3!Item = check<br> rst3!qty = rst!qty<br> rst3!cost = rst!cost<br> check2 = rst!cost<br> rst3!transdate = rst!daterec<br> rst3!vendor = rst!vendor<br> rst3.Update<br> rst3.Bookmark = rst3.LastModified<br> rst.MoveLast<br> i = 1<br> Else<br> rst.MoveNext<br> End If<br> Else<br> rst.MoveNext<br> End If<br> Loop<br> <br> rst2.MoveNext<br> Loop<br>---------------<br><br>Thanks!<br>