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.
