Hi Eric,

I think, You may want to query the occupancy and summarize it
(if this is possible within the SQL query of ADSM, it can be
done in one step).

Best regards

Andreas Peikert, Systems Programmer
   aMaDEUS Data Processing GmbH
   P.O. Box,   D-85424 Erding,   Germany
   Fon: +49 (0)8122 43-5805
   Fax: +49 (0)8122 43-3260
   email: apeikert AT amadeus DOT net

<* save a megabyte - do you really have to file this note *>