Recent content by italy47

  1. I

    Again on the IIF function

    Hello everybody! I try to reformulate my previous post more accurately in order to make clear the problem. I have these 2 tables: TblCustomers CstId CstName PaymentPeriod [monthly payments = m; quaterly payments = q] TblDebits DbtId DbtDate DbtDetalis [specifications of what is being...
  2. I

    Using IIF funcion

    Hi everybody! Sorry I forgot one field in the TblDebits, so the complete table is as follows: TblDebits DbtId DbtDate DbtDetalis [specifications of what is being charged] CstId [foreign key] I also wish to report the Sql code I’ve been trying which is: SELECT h.DbtDate...
  3. I

    Using IIF funcion

    Hello everybody! I have these 2 tables: TblCustomers CstId CstName PaymentPeriod [monthly payments = m; quaterly payments = q] TblDebits DbtId DbtDate DbtDetalis [specifications of what is being charged] I've been working at an MS Access query in order to get te following results...
  4. I

    New member just logged

    Hello everybody from Italy. I am not an expert Access user. That's why I am joining this forum :o Hope someone will help also with my poor English. Best regards to you all!
Back
Top Bottom