Go4Expert - create a master query

Go4Expert (http://www.go4expert.com/)

- MS Access (http://www.go4expert.com/forumdisplay.php?f=41)

- - create a master query (http://www.go4expert.com/showthread.php?t=1223)

create a master query

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.

Re: create a master query

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