SELECT DBA_INC_LOAN_BANK.LOAN_NUM, Nombre_Sucursales.NUMERO_SUCURSAL, Nombre_Sucursales.SUCURSAL, DBA_INC_LOAN_BANK.BRANCH_NUMBER
FROM (DBA_INC_LOAN_BANK INNER JOIN DBA_INC_MONTHLY_LOAN_MAIN ON DBA_INC_LOAN_BANK.LOAN_NUM = DBA_INC_MONTHLY_LOAN_MAIN.LOAN_NUM) RIGHT JOIN Nombre_Sucursales ON DBA_INC_LOAN_BANK.BRANCH_NUMBER = Nombre_Sucursales.NUMERO_SUCURSAL
WHERE (((Nombre_Sucursales.NUMERO_SUCURSAL)=CDbl(Right([DBA_INC_LOAN_BANK]![BRANCH_NUMBER],3))));