Search results

  1. I

    How to create a teble from a query

    Hi! I have a result of a query and i want to make a table from that result.
  2. I

    How To New

    Hi! I got this two pictures one is the query and the other is the result of the query now i just want to group by sucursal and how many are them.
  3. I

    How To

    Hi! In here you see the query and the result. In the result i need to group by sucursal and count by numero_sucursal. to see how many loan_num are by sucursal. and the rest i want it to stay as it is.
  4. I

    How do I?

    who can help me in this matter
  5. I

    How do I?

    i think i put it the wrong way and gave me various errors. and i want to export this to excel if this is possibble.
  6. I

    How do I?

    Hi! I want to count loan_num nad how many accounts by branch something like the picture of excel. if i need something else tell me. thanks appreciated
  7. I

    Now it gave me this

    thanks again but i made a mistake on counting is doing something that could gave the total of how many loan number of every sucursal and region the last field i forgot to tell you about it. how i can insert a picture of this that you could understand
  8. I

    Now it gave me this

    Yes that is the name of the table and it gave me this error in operator without () in query expression 'dba_inc_loan_bank.loan_num=dba_inc_monthly_loan_main.loan_num'
  9. I

    Now it gave me this

    Yes that is what i want to count sorry for not saying it i forgot so it would lokk like this SELECT DBA_INC_LOAN_BANK.LOAN_NUM, Nombre_Sucursal.NUMERO_SUCURSAL, Nombre_Sucursal.SUCURSAL, DBA_INC_LOAN_BANK.BRANCH_NUMBER FROM (DBA_INC_LOAN_BANK INNER JOIN DBA_INC_MONTHLY_LOAN_MAIN ON...
  10. I

    Now it gave me this

    sorry it won't happened again. so how i can count them
  11. I

    Now it gave me this

    and i want to count how many are they
  12. I

    If this is the correct join

    thanks brianwarnock
  13. I

    Now it gave me this

    Thanks Brianwarnock Now it ask me this
  14. I

    If this is the correct join

    so it could lokk like this 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); INNER...
  15. I

    If this is the correct join

    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...
  16. I

    If this is the correct join

    i have try this but the querie freeze i have to put end task to terminate the quey
  17. I

    I need to group by and count

    This is the query
  18. I

    I need to group by and count

    is a very large number of records
  19. I

    I need to group by and count

    In the form i have here there 4 columns the first one i have to count and group by branch_number. I have put group by and count in those coilums and take to long. the coulmn branch number has this criteria CDbl(Right([DBA_INC_LOAN_BANK]![BRANCH_NUMBER],3)) how i can put this because i want to...
  20. I

    Thaks but that is not what i'm looking for the code works

    Thanks! But that is not i'm looking for i have three coumns in a query one is the expr above the other one is the number of the bank that if is equal to the expreesion gave me the result of the third column that has the name description
Top Bottom