Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   create a master query (http://www.go4expert.com/forums/create-master-query-t1223/)

augie0216 17Aug2006 09:49

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.

shabbir 17Aug2006 10:40

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


All times are GMT +5.5. The time now is 10:38.