I have two tables that I have inner joined and then I am updating the database with new information and I need to use two separate update statements. Can someone please help me with this. I have it all set up, but I'm not sure how to execute each statement. Do I need to put Set objRS = objConn.Execute(strSQL) after each statement? Thanks.