udjamaflip
08-14-2008, 12:57 PM
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.
for each row in table
if row("col1").text = row("col2).text then
'do this....
end if
next
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.
for each row in table
if row("col1").text = row("col2).text then
'do this....
end if
next