[augie0216]

I have two tables that i'm trying to use to from a query. The talbes are as follows

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.

[shabbir]

The master query can be done based on the query condition and it will run different subqueries.