I'm having all sorts of trouble here. In short, I have 2 tables I'm comparing. A Master Data table and a Raw Data table. I'm trying to write code that will start at record(1) on Master table and find the same record on the Raw Data table. Once it finds the record then I want to compare each field on the Master record to that on the Raw Data record and output to a Corrections table when the Raw Data field(s) don't matchup. When it checks that record I goto next record on Master Data table and goto the First record on the Raw Data table and do search and check again until everything has been checked. Is there an easy way to maybe filter the Raw Data table to find the record, if so then how do I go about writing that code? Also, is there an easy way compare fields other than:
If rst.Field(1) <> rst2.Field(1) Then
With recCorrections
.Edit
.Field(1) = "*" & rst.Field(1) & "*"
.Update
End With
End If
The code will get long and cumbersome to do this check for all 10 fields for each record.
If anyone can offer any help on this I really appreciate it. Thanks.
If rst.Field(1) <> rst2.Field(1) Then
With recCorrections
.Edit
.Field(1) = "*" & rst.Field(1) & "*"
.Update
End With
End If
The code will get long and cumbersome to do this check for all 10 fields for each record.
If anyone can offer any help on this I really appreciate it. Thanks.
