i dont have any of my books here at work, so i figured id ask here.
let me explain my situation, and go from there.
i have two tables (lets call them t1 and t2) that have the same exact fields, just different data. i need to compare each field in t1 to each field in t2. then go back and compare each record in t2 to each record in t1. i was thinking a nested for loop (coming from a C++ background) but i remember something about a for each loop in vb
? can you have a for each loop and have the lcv be the recordset? for example:
for each recordSet in something?