mikcaau wrote:

> Doing something similar with patients in an hospital. Have patient
> table, InPatient table and Transfers table as patient moves from
> ward/care team to ward/care team.
> State can be determined when observation timestamp is between XFer_In
> TimeStamp and XFer_Out timestamp and
> InPatientId = XFer.PatientId

The state stuff is not too much of a problem, in your case we would
probably be looking to produce a report on 'bed occupancy' on an hour by
hour basis.

> Unfortunately I'm using Or***e. Has some neat functions though.

Does it have anything that helps with this particular 'rotation of axis'
between the data and the report? Always useful to know how the
competition do it :)

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php