J
julialatte
Far below is the question and the answer I already got. Now, I need to
compare the table Clean_Export with the fields Rec_Ident and Rec_Detail. If
they equal the same as the table Last_Week with fields LW_RecIdent and
LW_RecDetail the record can be deleted from Clean_Export but not from
Last_Week. If the records don't match I want the record in Clean_Export
field Rec_Detail to update the LW_RecDetail table with the new information.
Then, I need the code below reversed to populate a table called Ready with a
feild called field1. I want the two sets of data put back together into one
string.
PREVIOUSE QUESTION ANSWER
INSERT INTO Clean_Export (Rec_Ident, Rec_Detail)
SELECT Left([Field1],18), Mid([Field1],19)
FROM New_Export
compare the table Clean_Export with the fields Rec_Ident and Rec_Detail. If
they equal the same as the table Last_Week with fields LW_RecIdent and
LW_RecDetail the record can be deleted from Clean_Export but not from
Last_Week. If the records don't match I want the record in Clean_Export
field Rec_Detail to update the LW_RecDetail table with the new information.
Then, I need the code below reversed to populate a table called Ready with a
feild called field1. I want the two sets of data put back together into one
string.
PREVIOUSE QUESTION ANSWER
INSERT INTO Clean_Export (Rec_Ident, Rec_Detail)
SELECT Left([Field1],18), Mid([Field1],19)
FROM New_Export