dynamictiger
Registered User.
- Local time
- Today, 14:08
- Joined
- Feb 3, 2002
- Messages
- 270
I have a table set up called tblServJob, fields are:
JobDate
Who (Booked)
Client (lookup)
Address (lookup)
TimePromised (startTime)
AllocatedTime (hours allowed e.g. 2.5)
JobDescription
ServPerson(Lookup)
Discount
Access(lookup)
Payment(lookup)
I have another table tblServPerson that has the following Fields
ServPersonID
ServPerson
HourlyChargeRate
StartTime (e.g. 8.00 am)
EndTime (e.g. 5.00 pm)
What I would like to do is develop a query to find the next available time for this service person for a new entry into tblServJob. Although I have tried various queries I just can't get it to work. Anyone give me a hand please.
JobDate
Who (Booked)
Client (lookup)
Address (lookup)
TimePromised (startTime)
AllocatedTime (hours allowed e.g. 2.5)
JobDescription
ServPerson(Lookup)
Discount
Access(lookup)
Payment(lookup)
I have another table tblServPerson that has the following Fields
ServPersonID
ServPerson
HourlyChargeRate
StartTime (e.g. 8.00 am)
EndTime (e.g. 5.00 pm)
What I would like to do is develop a query to find the next available time for this service person for a new entry into tblServJob. Although I have tried various queries I just can't get it to work. Anyone give me a hand please.
