By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Time BETWEEN function

P: n/a
Faz
i have a DB which allows users to allocate trainers to course
sessions, they fill out date, start time , end time and other fields
and when they click on the trainer field I have a pop up which shows
the AVAILABLE trainers, i.e. it checks the existing session times and
only shows the ones who are not allocated to other sessions for the
same day and within the start time and end time entered.

I have one problem, the query doesn't pick up any unavailable trainers
where the time entered is before an existing time.
for example,

I have an EXISTING SESSION for Liam Cullen who is teaching at 09:00
(starttime) to 14:30 (endtime),

now if i enter a new session with starttime 10:00 and endtime 14:00,
Liam should not show up as he is UNAVAILABLE however this doesn't
work.

BUT for a new session if i have starttime as 09:00 and endtime of
14:00 liam is not showing up, hence unavailable which is correct.

I have found on many occasions that if the starttime i enter is after
an existing starttime, the trainers do not show up as unavailable when
they should.

I am using the BETWEEN function and everything else works fine except
for this one issue.

Thanks in advance.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
First I see that you need to define what unavailable means. Suppose Liam is
teaching between 07:00 and 10:05, is he available. How about 13:45 to 16:00? How
about if he eats lunch from 12:00 to 12:30?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Faz" <ch****@hotmail.com> wrote in message
news:a3*************************@posting.google.co m...
i have a DB which allows users to allocate trainers to course
sessions, they fill out date, start time , end time and other fields
and when they click on the trainer field I have a pop up which shows
the AVAILABLE trainers, i.e. it checks the existing session times and
only shows the ones who are not allocated to other sessions for the
same day and within the start time and end time entered.

I have one problem, the query doesn't pick up any unavailable trainers
where the time entered is before an existing time.
for example,

I have an EXISTING SESSION for Liam Cullen who is teaching at 09:00
(starttime) to 14:30 (endtime),

now if i enter a new session with starttime 10:00 and endtime 14:00,
Liam should not show up as he is UNAVAILABLE however this doesn't
work.

BUT for a new session if i have starttime as 09:00 and endtime of
14:00 liam is not showing up, hence unavailable which is correct.

I have found on many occasions that if the starttime i enter is after
an existing starttime, the trainers do not show up as unavailable when
they should.

I am using the BETWEEN function and everything else works fine except
for this one issue.

Thanks in advance.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.