create a master query

augie0216's Avatar
Newbie Member
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's Avatar, Join Date: Jul 2004
Go4Expert Founder
The master query can be done based on the query condition and it will run different subqueries.