create a master query

Discussion in 'MS Access' started by augie0216, Aug 17, 2006.

  1. augie0216

    augie0216 New Member

    Joined:
    Aug 1, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    I have two tables that i'm trying to use to from a query. The talbes are as follows

    Code:
    tblAppointment              tblPayments
    AppointmentID PK            PaymentID PK
    PatientID FK                AppointmentID FK
    AppointmentDate             PaymentAmount
    AppointmentCost             PaymentDate
    I was wondering if it is possible to create a master query if you will to show(calculate) Days that a balance is outstanding and the balance after a payment is made. Then run different queries off of that.

    I'f you need more details to answer this please let me know.
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    The master query can be done based on the query condition and it will run different subqueries.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice