strSQL = "UPDATE AccountAuthorizationInformation INNER JOIN AccountStatus ON [AccountAuthorizationInformation].[Account_Authorization]=[AccountStatus].[Account_Authorization] SET AccountAuthorizationInformation.Settle_Date = [AccountStatus].[Status_Date] WHERE (([AccountStatus].[Account_Authorization] = [AccountAuthorizationInformation].[Account_Authorization]) And ([AccountAuthorizationInformation].[Settle_Date]=''));"