MS ACCESS
Im making a schedule for a clinic that is run once every week. the treatment lasts for 6 weeks straight.
so a client is booked into a specific clinic from the date of 1st appointment(week 1 of treatment), till the 6th week(week 6 of treatment).
What i have is
-> the clinic's ID
-> Date for every wednesday it is run
-> Clients ID
-> Clients 1st appt date
-> Clients 6th appt date and
-> a clinic schedule table
What i want is a way to automatically add the clinic id into the clinic schedule for every wednesday from the 1st appointment to the 6th appointment.
any suggestions? please?
Im making a schedule for a clinic that is run once every week. the treatment lasts for 6 weeks straight.
so a client is booked into a specific clinic from the date of 1st appointment(week 1 of treatment), till the 6th week(week 6 of treatment).
What i have is
-> the clinic's ID
-> Date for every wednesday it is run
-> Clients ID
-> Clients 1st appt date
-> Clients 6th appt date and
-> a clinic schedule table
What i want is a way to automatically add the clinic id into the clinic schedule for every wednesday from the 1st appointment to the 6th appointment.
any suggestions? please?
Last edited: