Can you please tell me how to revise the statement below so I can make it match on 3 or 4 fields?
The current statement is:
rs.FindFirst field1= & rs2!field1
Basically I'm trying to compare two tables and there isn't a primary field to identify the record, so I need to combine multiple fields to make a primary field.
Of course, the easiest way to do this would be to use Office 365 and just dump the tables into Excel and do a compare, but I only have Office 2007 so I thought I'd just run a subroutine.