Appointment Time Falls In

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I have a database that is an appoitment book for some sales reps. They enter
the date, time of the appointment and the duration that the quote should
take. The finsih time is calculated by using the Dataadd feature (thanks Van
T. Dinh). But I need to be able to show the user if a sales rep already has
an appointment for this time period.

e.g.
Appointment_Date Sales_Rep Appointment_time
Duration
27/03/04 Dave 09:00 AM
2 Hours
27/03/04 Jim 09:00 AM
45 mins
27/03/04 Steve 09:45 AM
30 mins

User tries to insert a job for Dave at 10 AM for 30 minutes. Can anyone help
me with this. ANy help would be appreciated.

TIA
Stephen
 
It is really unlikely that anyone can help unless you describe in some
detail how you've set up the tables to hold your data. Without that
information, any "solution" would just be a guess.

Larry Linson
Microsoft Access MVP
 
Back
Top