Hi everyone,

Sorry if this is the wrong area to post about VBA questions, but I couldn't really find anywhere else within the forums


Basically I'm playing around with VBA in...Access 97 :|

...just....don't ask.


Anyway I want to loop through a table and compare two columns against each other in a function I've already made and tested.

If someone could give me a snippet of what I'm looking for i.e.
Code:
for each row in table
  if row("col1").text = row("col2).text then
    'do this....
  end if
next