Cond Format when Records are alike

[Guest]

Hello.

I have a subform with the following fields:

ScheduleDate (tied to the parent table and Form)
Name
LoginTime
LogoutTime

I would like to create conditional formatting on the login and logout fields
that will show folks how many people are scheduled around the same time in
future dates.
For example

June 15 2007 John 9:00am-10:00am
June 15 2007 Eva 9:30am-11:30am
June 15 2007 Earl 11:25am-12pm
June 15 2007 David 11:00am-12pm

I already have an expression that will tell me who currently is logged in
Time() >= [LoginTime] AND Time() <= [LogoutTime]

Now I need something to tell folks who are trying to schedule future dates.
For Example (above) John, Eva and Earl will be logged in at the same time on
June 15, 2007. I need those records to be yellow.

Is this possible?

Iram/mcp

 

[Marshall Barton]

Hello.

I have a subform with the following fields:

ScheduleDate (tied to the parent table and Form)
Name
LoginTime
LogoutTime

I would like to create conditional formatting on the login and logout fields
that will show folks how many people are scheduled around the same time in
future dates.
For example

June 15 2007 John 9:00am-10:00am
June 15 2007 Eva 9:30am-11:30am
June 15 2007 Earl 11:25am-12pm
June 15 2007 David 11:00am-12pm

I already have an expression that will tell me who currently is logged in
Time() >= [LoginTime] AND Time() <= [LogoutTime]

Now I need something to tell folks who are trying to schedule future dates.
For Example (above) John, Eva and Earl will be logged in at the same time on
June 15, 2007. I need those records to be yellow.

Logged in a WHAT same time?

From your example, I can see that John's time overlaps
Eva's, but not Earl's. OTOH, it looks like there is a five
minute period when Eva, Earl and David would all be logged
in.

It doesn't seem like using the system clock at any point
applies to some future date so I don't see how your
expression has any merit??

Note that if you want to determine if two periods of time
overlap, you would use an expression like:
TimeIn1 < TimeOut2 And TimeIn2 < TimeOut1