ShannonCallahan
asked on
Appointment Scheduler
Good evening experts,
I have a program that I am working on and one aspect of this program is scheduling appointments. I already have my forms created and have the ability to insert the data that is entered into the SQL Server. However, I have 2 combo boxes that have "travel time" to and from the appointment. The combo boxes offer set time limits such as, 15 mins, 30 mins, 45 mins, etc. I have 2 textbox feilds that offer start and estimated end time of the appointment. What I need to do is set the program up so that when the start and end time of the appointment is set and the travel time is selected, the program will not add the travel time to the "duration of appointment".
I.E.
Appointment start time: 0900
Appointment end time: 1000
Travel time there: 15 mins
Travel time back: 20 mins
Appointment duration: 0845-1020
Thank you all for your help in advance,
-ShannonCallahan-
I have a program that I am working on and one aspect of this program is scheduling appointments. I already have my forms created and have the ability to insert the data that is entered into the SQL Server. However, I have 2 combo boxes that have "travel time" to and from the appointment. The combo boxes offer set time limits such as, 15 mins, 30 mins, 45 mins, etc. I have 2 textbox feilds that offer start and estimated end time of the appointment. What I need to do is set the program up so that when the start and end time of the appointment is set and the travel time is selected, the program will not add the travel time to the "duration of appointment".
I.E.
Appointment start time: 0900
Appointment end time: 1000
Travel time there: 15 mins
Travel time back: 20 mins
Appointment duration: 0845-1020
Thank you all for your help in advance,
-ShannonCallahan-
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
---the program will not add the travel time to the "duration of appointment".---
You show it added in at the bottom so... is this the way it is, and you want to fix it? Or is that the way you want it, and are having a hard time getting it to show that way?
Let us know.