From: jfriedberg@mycomcast.com   
      
   Craig,   
      
   In general, I believe the advice you received last week included   
   restructuring your tables to include appropriate indexes and additional   
   fields.  For example, each admission record should also include a discharge   
   date/time field and an elapsed time (hours) field.  That will make it easy   
   both to calculate the number of hours and to retrieve those records   
   exceeding your target value.   
      
   Can these results also be achieved simply with queries and without adding   
   indexes or fields?  Not clear, because I'm not sure how easy it would be to   
   match up a new admission record with the correct older discharge record.   
   Also, whether a query can be used to "calc" the elapsed hours.  If the query   
   alone approach were workable, I'd be the first to say stick with it.  But if   
   you can't get it to do what you want, then go ahead and add the necessary   
   indexes and fields.   
      
   Taking the steps I've described might seem a bit more difficult now, but   
   won't seem that hard once they're done and will run much more efficiently.   
      
   If you want to discuss offline, please feel free to give me a call.   
      
   Jean   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)