Hello all-
Wondering if I could get some help.
I have two tables "tbl_GROWTH_Requests" and "tbl_GROWTH". I want to transfer/append all records from tbl_growth_requests to tbl_GROWTH, if they do not exist in tbl_Growth. The unique Identifier would be "Control" field
I am not sure what im doing wrong - Any help would be appreciated
DoCmd.RunSQL "INSERT INTO tbl_GROWTH " & _
"SELECT * " & _
"FROM tbl_GROWTH_Requests " & _
"WHERE NOT EXIST (" & _
"SELECT * FROM tbl_GROWTH " & _
" WHERE tbl_growth_requests.Control <> tbl_growth.control)"
Wondering if I could get some help.
I have two tables "tbl_GROWTH_Requests" and "tbl_GROWTH". I want to transfer/append all records from tbl_growth_requests to tbl_GROWTH, if they do not exist in tbl_Growth. The unique Identifier would be "Control" field
I am not sure what im doing wrong - Any help would be appreciated
DoCmd.RunSQL "INSERT INTO tbl_GROWTH " & _
"SELECT * " & _
"FROM tbl_GROWTH_Requests " & _
"WHERE NOT EXIST (" & _
"SELECT * FROM tbl_GROWTH " & _
" WHERE tbl_growth_requests.Control <> tbl_growth.control)"