Original User: solxenosActually it looks like I load all the parcel IDs into one array in the end. When populating the combined array I add the pipe symbol and a character that designates which table it comes from. Then I go through the array of parcel IDs and load the first and second item in the array into variables. If they differ then depending on the designator character and how that sorts I know which table is missing a value. I guess it would matter what form you Parcel IDs are in. For strictly numeric you may need to pad the parcel numbers with leading zeros to sort them properly as a string and compare them.Here is a scaled down snippet to show the logic I'm trying to explain when comparing the data. It's already loaded into one combined array of parcel IDS with the pipe symbol and table designator on the end. You will need to add a dummy record to the end of the array - I use "zzzzzzzzzzzzzz" so it will sort to the bottom. Array.Sort(CombineData)
Do Until i >= UBound(CombineData)
Var1 = Mid(CombineData(i), 1, (InStr(1, CombineData(i), "|") - 1)) ' gets parcel ID
Var2 = Mid(CombineData(i + 1), 1, (InStr(1, CombineData(i + 1), "|") - 1)) ' gets next parcel ID
If Var1 = Var2 Then
i = i + 1
Else
If Mid(CombineData(i), (InStr(1, CombineData(i), "|") + 1)) = "A" Then ' checks table designator
ListBox2.Items.Add(Mid(CombineData(i), 1, (InStr(1, CombineData(i), "|") - 1)))
ElseIf Mid(CombineData(i), (InStr(1, CombineData(i), "|") + 1)) = "Z" Then ' checks table designator
ListBox1.Items.Add(Mid(CombineData(i), 1, (InStr(1, CombineData(i), "|") - 1)))
End If
End If
i = i + 1
Loop