#### Topic: To compare two tables in ACCESS 2013 by means of VBA

Kind day!

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...)))