Looping through fields in a record set

Hi Guy,

Hopefully an easy one compared the others i have posted.

This is a bank account reconciliation. A user would have selected transactions that they want to match off (these are then stored in a temporary table). Once the user is happy with the transactions they have selected, they have the ability to then "confirm" and match transactions (to which point they move to matched status and removed from temp table).

My problem exists when the user confirms the match. I would like to run some controls to ensure all the essential data does in fact match. for example, I want to loop through all the records in the table and confirm all the fields match (exception of the amount). For example loop through all the records and see if the "Transaction Date", match in the table.

I have constructed the loop but unsure how to compare all the records to each other? Please may you show me how one would construct this this to compare all the records do actually match.


Set InfoRST = dbs.OpenRecordset(strSQL)
If Not (InfoRST.EOF And InfoRST.BOF) Then
InfoRST.MoveFirst
Do Until InfoRST.EOF = True

{INSERT COMPARISON CODE HERE}

{INSERT COMPARISON CODE HERE}

'Move to the next record.
InfoRST.MoveNext
Loop
End If