Link to home
Create AccountLog in
Avatar of ShannonCallahan
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-
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
I think I would need more clarification on your statement too...
---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.