Hi friends
I HAVE A PROBLEM AND NEED HELP
I HAVE A BASE OF DATA WITH THREE TABLES
IN THE FIRST TABLE AND IN SECOND I STORE THE DATA WHICH HIM I READ FROM A FILE I COMPARE THE DATA BETWEEN THEM AND I WANT HIM TO STORE IN THE THIRD TABLE. I HAVE REACHED IN THE STEP TO COMPARE THE DATA AND I NEED HELP AFTERWARDS THE COMPARISON HIM TO STORE. SOMEWHERE MAKE ERROR SOME DOES HELP?
sql2 = "SELECT lnlc.dn, kalod.dn, kalod.kk, kalod.kv, kalod.box FROM kalod INNER JOIN lnlc ON kalod.dn=lnlc.dn;"
Set rst2 = dbCUST.OpenRecordset(sql2)
Do While Not rst2.EOF If rst2!lnlc.dn <> "" Then
Debug.Print rst2!lnlc.dn
Else
rst2.MoveNext
End If
Loop
NIKOS
Enter your message below
Sign in or Join us (it's free).