From: craig.futterman@nospam.comcast.net   
      
   Liz, Egbert and Anders,   
   Thanks, as always, for your replies.   
   After doing a query which combines two tables from a specified time frame, I   
   am going through each of the records, one by one, and looking for records   
   which have the same medical record number and comparing the discharge   
   datetime with the admission datetime of the next record. The goal is looking   
   for patients who come back to the ICU within a specified period of time (24   
   or 48 hours). The purpose is to investigate why kids "bounce back" in a   
   short period of time.   
   According to what you suggest, I will have to create an index on the   
   hospital number field after the query which creates the table. Then, as I go   
   through the table with a scan loop, set the range for the hospital number,   
   compare records and find the "bouncebacks". I have to reset the range each   
   time the big scan loop goes to the next patient.   
      
   Does that sound correct? Can I go through a scan loop of the entire table   
   and use set range after each record?   
   Thanks for helping me with this complex project.   
   Craig   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)