1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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,276
    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