Topic: To compare two tables in ACCESS 2013 by means of VBA
I work with tables of a DB which got by right of succession.
It is necessary to compare table 1 (for example on value of a column 7) to table 2 (a column 7).
If the position misses in tab. 2 in table 1, for example in a column 8 to put down digit 777.
Earlier programmed in VBA EXCEL.
In VBA EXCEL it would look so:
Sub SEARCH () X1 = 2 X11 = 5984 X2 = 2 X22 = 6292 For XX1 = X1 To X11 Z1 = Sheets (1).Cells (XX1, 7) FL = 0 For XX2 = X2 To X22 Z2 = Sheets (2).Cells (XX2, 7) If Z1 = Z2 Then FL = 1 Next XX2 If FL <> 1 Then Sheets (1).Cells (XX1, 7) =777 End If Next XX1 End Sub
How it can look in ACCESS (there should be something similar - both there and there VBA)?
If that - and boots I ask not to rush...)))