dynamictiger
Registered User.
- Local time
- Today, 03:34
- Joined
- Feb 3, 2002
- Messages
- 270
Okay, I have a form which shows the service persons. When you select one I have a query which goes and finds their next available start time and suggests this as the best time for the job. If you then enter a duration which goes past the end of the day, by default the form defaults the start time to the servicemans start time the following day. This is all powered through a series of queries.
Under this scenario we could have an appointment at say 9.00 am on Tuesday, with a last appointment finishing at 2.00 pm on Monday.
I now need to write a query to test all new jobs booked to see if they will fit between 2.00 pm on Monday and say 4.30 pm on Monday (knock off time). Trouble is I am getting confused and can't see how to do this...
Under this scenario we could have an appointment at say 9.00 am on Tuesday, with a last appointment finishing at 2.00 pm on Monday.
I now need to write a query to test all new jobs booked to see if they will fit between 2.00 pm on Monday and say 4.30 pm on Monday (knock off time). Trouble is I am getting confused and can't see how to do this...
