Compare Records & Move to new table in VBA

[Tom]

I want to make a loop whereby i can compare the first record with every other
record until i find a 'True' comparison, if i find this, move the records
into a new table, otherwise, move onto the second record and repeat.

I figured i would do this with a for next loop, i have done them in excel,
but im not certain of how to compare cells in access.

Thanks

Tom