1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,285
    Likes Received:
    364
    Trophy Points:
    83
    The master query can be done based on the query condition and it will run different subqueries.
     

Share This Page