Seeking help on a complex problem

From: <pollachi_at_my-deja.com>
Date: Tue, 13 Jul 1999 02:25:32 GMT
Message-ID: <7me82i$60s$1@nnrp1.deja.com>

Hi All,

I have a problem to solve and am seeking the help of you gurus out there.

There is a table with access information, eg.,

Person Place     Time
====== =====     ====
P1       A       10:01 AM ---> First entry for P1
P1       B       11:00 AM ---> Crossover to B
P1       A       12:15 PM ---> Double xover to A


P2       B       10:10 AM ---> First entry at B for P2
P2       B       11:00 AM ---> Re-entry at B for P2
P2       A       11:15 PM ---> Crossover to A for P2
P2       B       12:11 PM ---> XX over to B

Here are the rules :

If the person goes from A to B it is crossover to B If the person goes from B to A it is crossover to A If the person goes from A to B first and then from B to A, it is double crossover to B
If the person goes from B to A first and then from A to B, it is double crossover to A

I need to get this information at any given time interval say,  every 15 minutes.

In the above example, the output should be

             First
Time Place Entry Xover_to_A Xover_to_B XXover_to_A XXover_to_B ==== ===== ===== ========== ========== =========== ===========

10:15  A         1           0          0           0           0
10:15  B         1           0          0           0           0

.
.

11:00 A 0 0 1 0 0
.
.

12:15 A 0 0 0 1 1
.
.

and so on ..

Please let me know if there is any simple of doing this?

Thanks in advance

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 12 1999 - 21:25:32 CDT